Set Analysis

[Nikhil2725]

Hi All,

How to convert the below expression into the Set analysis..

Round([SumOfGrossValue_LC]-[SumOfCOGS_LC])/[SumOfGrossValue_LC],2)

[Vegar]

What do you want to do with set analysis? Your expression looks fine. However it looks like you have an issue with paranthesis, one to many on the right ore one to little to the left.

Round([SumOfGrossValue_LC]-[SumOfCOGS_LC])/[SumOfGrossValue_LC],2)

[Nikhil2725]

Hi Vegar,

I want to recreate the same using Set analysis...

 Because I have 2 conditions to put into the Set analysis..

[Vegar]

Try like this

Sum( {<FieldA ={Something}, FieldB ={SomethingElse}>} Round(...))