Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to do a 3 month range sum in a pivot table using rangesum before -
(rangesum(Before(total sum({<[PO Month Value]=>}[Total OT]),0,3)))
There are gaps in the data. Is there anyway, in case of a null measure, I can have the rangesum of the previous 2 measures and put in the place of null and also the next one to consider the 2 months where the measures were not null?
For example in the screen shot - first row, Jun-20 is no value. I would like to have Apr-20+May-20 (+jun-20 which is null) to be there for Jun-20, and then have may-20+jul-20 (since Jun-20 is null) for jul-20 values?
So basically put 0s for the gaps (jun-20) without changing in the underlying data tables.
Thanks!!
hi,
Use Alt() like below
=Alt(Expression, 'Value If expression returns null')
Example:
=Alt(100/0, '0')
or try this link for more
Hope this helps you.
ksrinivasan