RSUM returning errors for query

[amelia]

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!

[Angelina_QBeeQ · Accepted solution]

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

[Angelina_QBeeQ · Accepted solution]

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

[amelia]

Thanks for the fast reply!!

[harikm007 · Accepted solution]

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]

thank you!!