Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
6 years ago

Null formula help

return .999 to numeric formula field [bd ct/del vs bd ct/wo +/-] if    [PDW.Board Count - DELIVERED] is blank/empty otherwise [Job - BOARD COUNT PER WO]-[PDW.Board Count - DELIVERED] --------...
AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years ago
Lynne,

Empty numeric fields are treated as zero by default, try using this code in your formula numeric field, [bd ct/del vs bd ct/wo +/-]:

If(
[PDW.Board Count - DELIVERED]=0,
0.999,
[Job - BOARD COUNT PER WO]-[PDW.Board Count - DELIVERED]
)


If that doesn't work, ensure that the 'Treat blank values as "0" in calculations' option is checked:

Here is a working example:






------------------------------
Adam Keever
------------------------------
  • BuildPro's avatar
    BuildPro
    Qrew Captain
    6 years ago
    Thank you....I was treating the field as a text field.  I should have known better!



    ------Original Message------

    Lynne,

    Empty numeric fields are treated as zero by default, try using this code in your formula numeric field, [bd ct/del vs bd ct/wo +/-]:

    If(
[PDW.Board Count - DELIVERED]=0,
0.999,
[Job - BOARD COUNT PER WO]-[PDW.Board Count - DELIVERED]
)


    If that doesn't work, ensure that the 'Treat blank values as "0" in calculations' option is checked:

    Here is a working example:






    ------------------------------
    Adam Keever
    ------------------------------