cancel
Showing results for 
Search instead for 
Did you mean: 

RSUM ON DAYS WITH 0 DAILY VALUE

cartercjb
10 - ETL
10 - ETL

 I have the following pivot:

cartercjb_0-1650346637004.png

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

Thanks!

-Carter

6 REPLIES 6

Ayantek
8 - Cloud Apps
8 - Cloud Apps

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.

Ayantek_1-1650349572237.png

 

Ayantek_0-1650349528715.png

 

Thanks

Ayantek

Hi Ayantek @Ayantek ! I apologize I definitely should have provided more detail upfront.

Here is a more detailed screenshot:

cartercjb_0-1650354063641.png

 $ 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_QBeeQ
10 - ETL
10 - ETL

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: 

cartercjb_0-1650387123194.pngcartercjb_1-1650387128055.png

 

 

Maybe this could help 

Angelina_0-1650393927121.png

 

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

 

cartercjb_0-1650396381082.png

cartercjb_1-1650396383944.png