Discussions

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")

Basically the assumption is if there is data in the report link Related Scheduled Job then it is scheduled.

Thanks for the help.

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")