Show only missing and 0 values

[#1]

Hi!

I've got three tables, Item, Sales and Forecast:

In an object, I want to show only the Items (ItemNr and ItemName) where Forecast is set to 0 or missing at all.

In this case, the result should be:

[sunny_talwar · Accepted solution]

Try this expression

=If(NullCount(Forecast) > 0 or Forecast = 0, 'Show')

with ItemNr and ItemName as dimensions

[#3]

Hi ,

You can try like this also .

Regards