The use case is that you create a custom table for storing financial/budgeting type data for a project. You add a number custom field for "Planned Spend" and another number custom field for "Actual Spend". The desire is to have another calculated field named "Spend Delta" that would be derived based on a calculation of "Planned Spend" - "Actual Spend" which would be specified as part of the "Calculation" type properties. Similarly, you might want to have a derived custom field that displays the % of Budget Spent so the custom field properties would allow you to specify the equation is "Actual Spend"/"Planned Spend".
I used a custom table example but it should be available as a general custom field option. But, it seems especially compelling to be able to perform operations between different fields in a custom table.
|Release time frame|
It is now possible to create calculated fields with worksheets.
Think of worksheets in Aha! as two-column spreadsheets. You can create as many rows as you need and they automatically calculate data. You can use worksheets to do basic math — add, subtract, multiply, and divide. But you can also perform more complex functions, such as averaging or calculating the time between two dates.
With this initial release, worksheet fields can reference any other worksheet field. We are actively working on an enhancement that would allow worksheets to reference any other field in Aha! We will keep this idea updated as we make progress there.