Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to create a list box and remove the values that dos not have any available data. I have tried a few different formulas with no success. For instance if AM Compliance doesn't have any available data I don't want it to appear in the list box.
May be create a flag in the script...
LOAD If(Len(Trim(Field1&Field2&Field3.....&FieldN)) = 0, 0, 1) as DataFlag,
....
FROM ....;
and then this as your calculated expression for list box object
Aggr(If(Max(DataFlag) = 1, Region), Region)
Try Expression
Aggr(Region,Region)
Regards,
Antonio