Forum Discussion

JasonBeaver's avatar
JasonBeaver
Qrew Cadet
8 years ago

IF STATEMENT TO KNOW IF REPORT LINK IS POPULATED

I am wanting to write an IF statement to tell me if a report link has any data in it. It tried this IF statement but it does not change IF([Scheduled Job]=null, "Scheduled", "Not Scheduled") Bas...
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
I think you mean to say 'Reference field'. 

If thats the case, numeric reference fields will have a null value, but act like a "0" by default.

You can change the field properties for the reference field, or do what I do and just change the logic in the formula (faster for me)

">0" rather than "=null"

IF([Related Scheduled Job]>0, "Scheduled", "Not Scheduled")