Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to get only the records for shipping id which location id has values.
Shippng id | LocationNo | BldgNo | Amount |
231 | 1 | 1 | 0 |
231 | 2 | 1 | 250 |
231 | 3 | 1 | 0 |
Output Expected:
Shippng id | LocationNo | BldgNo | Amount |
231 | 2 | 1 | 250 |
Sum({<LocationNo={"=Sum(Amount)>0"}>}Amount)
Another option would be using formula:
Sum(Amount)
and under add-ons deselect "Include zero values".
G'day @MEDHA07,
I think I would convert all zero values in the load script to NULLs and then, in the table, exclude NULL values.
Cheers,
Barnaby.
Hi Harish, In addition to, you can use on the Base dimension in side the set. Like Shipping id, etc