RSUM ON DAYS WITH 0 DAILY VALUE

[cartercjb]

 I have the following pivot:

Why does the RSUM show a value of $0 on 4/3 instead of (92+428+0)?

Thanks!

-Carter

[Ayantek]

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

[cartercjb]

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. 

[Angelina]

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.

[cartercjb]

Thank you for the suggestion, Angelina @Angelina ! Unfortunately, I get the following error when I try your suggestion: 

[Angelina]

Maybe this could help 

[cartercjb]

@Angelina 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.