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 this: RSUM(COUNT([id]), [filter]) and the error is in the screenshot!

Dashboards & Reporting
  • 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

4 Replies

Replies have been turned off for this discussion
  • 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