Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Having difficulties with this formula, no matter how simple I make it. Basically I'm dealing with financial data, where a field needs to represent a running sum (aggregated to the field value to the left of it, for the previous fiscal period).
When I isolate just a single row of data, the aggregated sums are represented correctly.
But when I have multiple rows (ie. separate balance sheet items), the formula doesn't consistently add to the previous - before - value, but seems to sometimes reset along the way.
Simple example that I'm using that shows this issue: =rangesum(before(sum(Budget),0,ColumnNo()))
Anyone run into a similar issue? I must be doing something wrong here.
Thanks,
Matt
Try =rangesum(before(sum(Budget),0,ColumnNo(TOTAL)))
Do we need another TOTAL?
=RangeSum(Before(TOTAL Sum(Budget), 0, ColumnNo(TOTAL)))
Probably, good call.
I've tried both of your suggestions and the values shown are consistent with what they were before (incorrect when multiple rows are showing).
Would you be able to share a sample or some screenshots? We might be missing something here
This is correct (isolated a single IncomeGroup).
This is the same incomegroup shown without being filtered out, showing the same periods. Note I have the same issue for both Income and Budget expressions.
Are you using if statements or set analysis in your expression to restrict something? I am not 100% sure what might be going on here....