Get Free Trial

Running Totals of Calculated Value

Answered
Eric asked on April 28, 2021

I have two columns – Forecast Cost and Actual Cost – and a Calculated Value UpdatedCost = if(ActualCost>0, ActualCost,ForecastCost). I’m trying to do a running total of the UpdatedCost column as ‘TotalCost’ but it just matches the UpdatedCost column. 
See xls sample attached  and snapshot of Flexmonster.

Attachments:
pivot.xlsx

1 answer

Public
Vera Didenko Vera Didenko Flexmonster April 30, 2021

Hello, Eric,
 
Thank you for reaching out to us.
 
We would like to kindly explain that Flexmonster doesn’t support applying built-in aggregations on calculated values at the moment.
Currently, the recommended approach is to apply the "Running Total of Column" aggregation on an existing field in the data set.
 
Please let us know if other questions arise.
 
Kind regards,
Vera

Please login or Register to Submit Answer