Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following output on the dashboard
Material Inventory Qty Safety Stock Bookings Qty Excess Inventory Qty Excess Inventory $
ABC 1000 500 200 1000-500-200 = 300 $100
XYZ 100 500 200 (600) ($250)
How can i filter the data such that it shows only those rows that have a positive value in the excess inventory column and excess inventory $ column?
Hi,
Try this,
= if(([Inventory Qty] - [Safety Stock] - [Booking Qty]) > 0, ([Inventory Qty] - [Safety Stock] - [Booking Qty]))
Hope it helps
I currently use this expression but it still displays material XYZ with no value in the excess inventory qty column. I don't want to display the material at all if the excess inventory quantity is negative.
Thanks
Depending on the kind of controller, you may tell it to hide null values using the formula passed by
check the post "damn you zero and nulls" on http://qlikman.blogspot.com.br/