Null formula help

Question

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]

------------------------------
Lynne8817 Lynne8817
------------------------------

adamkeever1 · Answer

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 · Answer

Thank you....I was treating the field as a text field.&nbsp; 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: