Forum Discussion

6 Replies

Replies have been turned off for this discussion
  • Ayantek's avatar
    Ayantek
    Cloud Apps
    04-19-2022

    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's avatar
      cartercjb
      ETL
      04-19-2022

      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_QBeeQ's avatar
    Angelina_QBeeQ
    ETL
    04-19-2022

    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.