Running Totals For Calculated Values

Hello,

I am using a calculated metric to output the result of an If expression, which outputs a '1' per row when the condition is met and a null value when it is not met. The If expression is using values from a separate external report that is then populating them into the Flexmonster instance. However, the running total/aggregation for the '1' values do not add up to a correct subtotal across the rows inside the calculated metric column, and instead convey the same '1' value for any primary rows containing sub-rows with a '1'.

• In screenshot 1- One of the areas where the total is expected has a callout next to it where I state the subtotal should be 5 instead of 1.
• In screenshot 2- Displays the formula I'm using to produce these values. I've also tried to use different distinctcount, count, runningtotals functions to achieve the desired result, but to no avail.
  • Formula: If((sum("CustomColumn26") /sum("CustomColumn27")*100)>3,1,"")
• Note: Screenshots are from a test company and do not display any type of sensitive, real data.

Has anything changed in the last 3-4 years to support this or is there another workaround I can try? Will this be available in a future release.

Cited ticket with a similar question/request: https://www.flexmonster.com/question/running-totals-of-calculated-value/

Thanks for any insights you can provide!