Hello,
I have a report based on a query. Query is in order based on a table. I need one of the fields in my report shows "Not Applicable" when a criteria is met.
I used this code in expression builder but it didn't work:
I was trying to say if [place_detail] = "Home" then change the word "Home" to "NOT APPLICABLE"
Is there anyway of doing it properly?
Thank you
I have a report based on a query. Query is in order based on a table. I need one of the fields in my report shows "Not Applicable" when a criteria is met.
I used this code in expression builder but it didn't work:
Code:
= iff("Home","NOT APPLICABLE", [place_detail])
Is there anyway of doing it properly?
Thank you