In situations where you need custom calculations, formula custom attributes are a powerful way to bring this to your Placker boards.

It is similar writing formulas in Excel, but in Placker you can use other fields as variables, as will be introduced in this article.

These are some examples of formulas that may be useful depending on your working context, where an equation may contain other custom attributes, and the result is the Formula custom attribute:

  • Cost of hours worked: Hourly rate * Effort * 60

  • Cost performance index: Earned Value / Actual Cost

  • Total area = Area 1 + Area 2 + Area 3

  • Price in US Dollars = Price in Euros * 1.13

  • Profit = Incomes - Expenses

The steps of creating this type of attribute are quite similar to other custom attributes. Check the recording below to see the creation of an attribute (Profit) to calculate the difference between two number custom attributes (Incomes and Expenses):

Editing a formula

To edit a formula, also open the board settings and custom attributes, but click "Edit" next to your formula custom field to make the changes needed. After that, remember to click the "SAVE" button at the right of the expression:

Did this answer your question?