Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to write set analysis to get sum of sales for region where region is null;
i.e only null region sales
sum({<region={" "}>}sales)
May be flag the null region in the script like this
If(Len(Trim(Region)) = 0, 1, 0) as NullRegionFlag
and then this
Sum({<NullRegionFlag = {1}>}Sales)
try this
sum({$<region={"=isnull(region)"}>} sales)
Not going to work
not tested sunny
I am letting you know that it is not going to work.... and the reason is that you can't really compare a null field value within set analysis..... if it was white space, this would have worked
sum({$<region={"=Len(Trim(region)) = 0"}>} sales)
Nice sunny let me try with the dummy data for my understanding ....
Sounds like a plan... share the sample afterwards as it might help someone else
sure sunny