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.
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.