cancel
Showing results for
Did you mean:

# RSUM ON DAYS WITH 0 DAILY VALUE

10 - ETL

I have the following pivot:

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

Thanks!

-Carter

6 REPLIES 6
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.

Thanks

Ayantek

10 - ETL

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.

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:

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.

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum: