Hi. What is the correct syntax for the 'Show ...

(PDM Business Support) #1

Hi. What is the correct syntax for the ‘Show If’ function if I want to show the Field based on the value of another field being 1 of 2 of the 4 options available?

e.g. Show [Bale Qty] if [Category] = “Timber” OR “CSP”

(Roberto Juárez) #2

Go to [Bale Qty] column then go to the field “Show if” and write this: OR([Category] = “Timber”, [Category] = “CSP”)

(Philip Garrett) #3

@PDM_Business_Support

Try:

OR([Category] = “Timber”, [Category] = “CSP”)

(PDM Business Support) #4

Thank you guys