Display Records Based On Two Calculated Measures

mahmooddba — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Please find the attachment for the details , I need to get the items with zero "Stock Quantity" measure & not null "Last Bill Date" measure

Note: last bill date having null values

Thanks

Mahmood

Re: Display Records Based On Two Calculated Measures

sunny_talwar — Thu, 14 Dec 2017 12:37:41 GMT

May be add this to your set analysis

{<[LAST BILL DATE] = {"*"}>}

This should exclude all nulls in LAST BILL DATE from the chart