cancel
Showing results for 
Search instead for 
Did you mean: 

RSUM returning errors for query

amelia
10 - ETL
10 - ETL

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!

2 ACCEPTED SOLUTIONS

Angelina
9 - Travel Pro
9 - Travel Pro

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

View solution in original post

harikm007
12 - Data Integration
12 - Data Integration

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

View solution in original post

4 REPLIES 4

Angelina
9 - Travel Pro
9 - Travel Pro

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

Thanks for the fast reply!!

harikm007
12 - Data Integration
12 - Data Integration

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

thank you!!

Voice of Customer
Impact Business Intelligence (BI) and Analytics Market Research

Click Here & Complete Dresner's Wisdom of Crowds® Market Study Survey Today!

Community Toolbox

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

Need additional support?:

Community Support Request

Don't miss out:

Earn a BETA Launch Challenge Badge!