RSUM ON DAYS WITH 0 DAILY VALUE
I have the following pivot:
Why does the RSUM show a value of $0 on 4/3 instead of (92+428+0)?
Thanks!
-Carter
Forum Discussion
Hi cartercjb ,
Can you share the formula screenshot, that you are using in the Formula/Value section of Pivot.
It should work if you use normal Rsum.
Thanks
Ayantek
Hi Ayantek Ayantek ! I apologize I definitely should have provided more detail upfront.
Here is a more detailed screenshot:
$ METRIC = DAILY REVENUE AMOUNT
sum([Negotiated Therapy Amount ( Revenue)])RSUM WEEKDAYS = RSUM OF WEEKDAY REVENUE ONLY
if ( ([# of unique Days in Date],[WEEKEND])>0, RSUM(([Total Negotiated Therapy Amount (Revenue)]))-Rsum(([Total Negotiated Therapy Amount (Revenue)],[WEEKEND])), Rsum(([Total Negotiated Therapy Amount (Revenue)],[Weekday])) )The attached workbook shows what I am trying to replicate in Sisense.
