Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set analysis with nested function and greater than value

Hi all,

I have to find sum of price, where round(price,1) >0 using set analysis.

1 Reply
sunny_talwar

What is the dimension where you are checking round(price, 1) > 0? May be try this

Sum({<Dimension = {"=round(Sum(price), 1) > 0"}>} price)

or this

Sum(RangeMax(round(price, 1), 0))