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 !
You could use this formula for your goal:
RSUM(
if ( ([# of unique Days in Date],[WEEKEND])>0,
0,
sum([Negotiated Therapy Amount ( Revenue)])
)
)Here we just replace our values for weekend with 0 and make Rsum.
Thank you for the suggestion, Angelina Angelina_QBeeQ ! Unfortunately, I get the following error when I try your suggestion:
Maybe this could help
Angelina_QBeeQ this is definitely helpful! I am tracking what you are trying to do. Unfortunately, I ended with the same result. It has something to do with the RSUM function of the last metric, I just can't figure out what.
