Forum Discussion

JasonBeaver's avatar
JasonBeaver
Qrew Cadet
7 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")

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

Thanks for the help.
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    7 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")