Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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