Hi,
I currently have an issue with the Range Sum / Accumulation in QV when trying to use a line chart. I have attached an example to demonstrate. I am not sure how to get the accumulation to work as required.
In my Example, please note the following objects (Screenshot Below)
Thanks in advance
Regards
Tyron
Try this
RangeSum(Sum(TOTAL <TreatyYear> Amount), -Aggr(RangeSum(Above(Sum(Amount), 1, RowNo())), TreatyYear, DateKey))
Try this
RangeSum(Sum(TOTAL <TreatyYear> Amount), -Aggr(RangeSum(Above(Sum(Amount), 1, RowNo())), TreatyYear, DateKey))
Thank you very much for your assistance Sunny.
The only issue I found is if you have any logic on your dimensions such as using as Left or Date# etc. and even add this to the expression, it breaks. But its a easy fix by just moving the formatting to script 🙂