Skip to main content
Question

Null formula help

  • Sep 11, 2019 6:38 PM UTC
  • 0 replies
  • 30 views

Forum|alt.badge.img+11
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
------------------------------
This topic has been closed for replies.

AdamKeever1
Forum|alt.badge.img+2
  • Qrew Commander
  • Sep 12, 2019 1:11 PM UTC
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
------------------------------