Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to create a pivot with a cumulative sum based on current and previous financial year and split between periods.
The previous year works great with the below expression, however the current year fills the future periods with the same value as the last month of data as there is no data yet in the system.
Could someone provide a solution how to stop periods with no data copying what is in the previous period.
I.e. April displays £15m and then all the periods after do also as I believe it is just looking at the previous period and trying to add an additional value.
=rangesum(before(Sum({$<Grouping={"Income"}>}Actual),0,columnNo()))*-1
Thanks
May be this
=If(Sum({$<Grouping={"Income"}>}Actual) > 0, RangeSum(Before(Sum({$<Grouping={"Income"}>} Actual), 0, ColumnNo()))*-1)
Thanks Sunny this helped me out.