topic Re: how to show only data for where it has values in App Development

how to show only data for where it has values

MEDHA07 — Fri, 02 Dec 2022 18:21:02 GMT

Hi All,

I need to get only the records for shipping id which location id has values.

Output Expected:

Shippng id	LocationNo	BldgNo	Amount
231	2	1	250

BrunPierre — Fri, 02 Dec 2022 19:01:58 GMT

Sum({<LocationNo={"=Sum(Amount)>0"}>}Amount)

RsQK — Sat, 03 Dec 2022 08:22:17 GMT

Another option would be using formula:

Sum(Amount)

and under add-ons deselect "Include zero values".

barnabyd — Sun, 04 Dec 2022 21:19:54 GMT

I think I would convert all zero values in the load script to NULLs and then, in the table, exclude NULL values.

Cheers,

Barnaby.

Chintam — Mon, 05 Dec 2022 10:42:07 GMT

Hi Harish, In addition to, you can use on the Base dimension in side the set. Like Shipping id, etc