nested set analysis

[#1]

Hi All,

could you please let me know how to include set analysis in another one?

lets say i need to have sum({<Flag1={1}, sum(Costs)<>0 >} Sales)

I'm not sure how to surround the sum(Costs)<>0 with brackets and apostrophes.

Many thanks in advance

Tommy

[sunny_talwar · Accepted solution]

May be like this:

Sum({<Flag1 = {1}, OrderID = {"=Sum(Costs) <> 0"}>} Sales)

Here OrderID is the field where you want to check if Sum(Cost) <> 0 or not. You might need to use another field based on your requirement