Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
canmarroig
Partner - Creator
Partner - Creator

Syntax on set analysis instead of if condition

I need to calculate a KPI only if a dimension is greater than a number set in a variable

Sum({<Dimension={"=COUNT(Dimension)>$(vNumber)"}>} XXXXXX)

but it doesn't work, i don't want to use if condition for performance troubles, is it possible?

Tks

Labels (1)
1 Reply
pradosh_thakur
Master II
Master II

generally it should be
Sum({<a unique field other than dimension ={"=COUNT(Dimension)>$(vNumber)"}>} XXXXXX)

but anyways if you replace the variable with a number , let's say 5 , does it work?
Learning never stops.