Reports calculated column (Sum, Difference, Divide, Multiplication, Expression)

Created by Erik Åkerlund, Modified on Wed, 7 Feb at 3:37 PM by Jenny Johansson

It is possible to select a report column called (Sum, Difference, Divide or Multiplication) directly in a report to show the sum or difference of two report columns. There is also a column called Expression where you can write your own expression directly in the report.


See example below in a balance report where the total cost is calculated from the Period interest amount and Period Fee amount column by adding them together.


Click new report column select Sum 

 

Select the two columns you want to add together.



The sum is shown in the new column:


Same thing is possible to do then for the other types as well (Difference, Multiplication, Divide and also your own Expression).

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article