I am trying to hide a column "initial deliver...

(Andy Hambleton) #1

I am trying to hide a column “initial delivery quantity” in a deliveries form if it is the second or any subsequent delivery to the same address( a key value). The idea being when you pick the delivery address from the dropdown menu on the delivery form, it will hide the “initial delivery quantity” from the form if I’ve delivered their before. Can’t get me head round the problem. Can anyone help? Tried this in the show_if section:

COUNT(SELECT(Deliveries[Product], [Address] = [Address Name]))=0

“Address” in the Deliveries table and is a REF to “Address Name” in the customer table

(Aleksi Alkio) #2

How about COUNT(SELECT(Deliveries[Product], [Address] = [_THISROW].[Address Name]))=0

(Andy Hambleton) #3

Worked a treat, thanks Alkio.

(Aleksi Alkio) #4

You’re welcome