Output a value as NULL

Janet_21505
Janet_21505 Altair Community Member
edited March 2021 in Community Q&A

Is is possible to output a NULL value in an IF statement.  

If([Unearned Deferred Costs1]>0 .OR. [Unearned Deferred Fees1]>0,"Deferral - Deferral 1",'') creates a blank which is getting picked up in a Count function.

Janet

Tagged:

Best Answer

  • CPorthouse
    CPorthouse
    Altair Employee
    edited March 2021 Answer ✓
    Janet_21505 said:

    Unfortunately the IF expression did not like 1/0.  

    Sorry, I should have suggested:

    str(1/0)

    because you are outputting a character field.

Answers

  • CPorthouse
    CPorthouse
    Altair Employee
    edited March 2021

    try using 1/0

  • Janet_21505
    Janet_21505 Altair Community Member
    edited March 2021

    Unfortunately the IF expression did not like 1/0.  

  • CPorthouse
    CPorthouse
    Altair Employee
    edited March 2021 Answer ✓
    Janet_21505 said:

    Unfortunately the IF expression did not like 1/0.  

    Sorry, I should have suggested:

    str(1/0)

    because you are outputting a character field.

  • Janet_21505
    Janet_21505 Altair Community Member
    edited March 2021

    That is exactly what I needed. Thanks Chris!

Categories