Discussions

Expand all | Collapse all

I need a text field to show NA if a numeric field is Null and then ""True"" if it is 0

  • 1.  I need a text field to show NA if a numeric field is Null and then ""True"" if it is 0

    Posted 02-05-2019 20:56
    I need a text field to show NA if a numeric field is Null and then "True" if it is <0 and "False" if  >0


  • 2.  RE: I need a text field to show NA if a numeric field is Null and then ""True"" if it is 0

    Posted 02-05-2019 21:03
    try this

    IF(
    IsNull([my field]), "NA",
    [my field] <0, "True",
    [my field]>0,"False",
    [my field]=0, "I'm not sure what you want this to be")


    note: with numeric fields, null and zero and not necessarily the same.  It depend either on the formula that calculated the result or if its a data entry field, then how the field properties are set for how to treat blank.




  • 3.  RE: I need a text field to show NA if a numeric field is Null and then ""True"" if it is 0

    Posted 02-05-2019 21:25
    Thank you!