Forum Discussion

amelia's avatar
amelia
ETL
07-06-2022
Solved

RSUM returning errors for query

Hi! When I try to do the RSUM calculation for this metric, there is an error. I am trying to do a running sum of the number of ids, but I need to filter it based on a condition. The calculation is th...
Dashboards & Reporting
  • Angelina_QBeeQ's avatar
    Angelina_QBeeQ
    07-06-2022

    Hi amelia ,
    try this one :
     RSUM( (COUNT([id]), [filter])  )

  • harikm007's avatar
    harikm007
    07-06-2022

    Hi amelia ,

    Try adding one more pair of brackets:

    RSUM((COUNT([id]), [filter]))

    One pair is for COUNT and filter and other is for RSUM

     

    -Hari

harikm007's avatar
harikm007
Data Warehouse
07-06-2022

Hi amelia ,

Try adding one more pair of brackets:

RSUM((COUNT([id]), [filter]))

One pair is for COUNT and filter and other is for RSUM

 

-Hari

  • amelia's avatar
    amelia
    ETL
    07-06-2022

    thank you!!