Skip to main content
Question

Null formula help

  • September 11, 2019
  • 0 replies
  • 18 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
------------------------------

    AdamKeever1
    Forum|alt.badge.img+2
    • AdamKeever1
    • Registered
    • September 12, 2019
    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
    ------------------------------
    Terms & ConditionsAccessibility statement