Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have to find sum of price, where round(price,1) >0 using set analysis.
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))