ISNULL assistance needed, please

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Please show me how the formula should be written?

Field Name: [# +/- BOARDS DEL VS BLDR] (numeric formula type)

If
[# ***TOTAL*** BOARDS DELIVERED] is blank,
leave [# +/- BOARDS DEL VS BLDR] blank.

Otherwise...return value representing:
[# ***TOTAL*** BOARDS DELIVERED]-[Order - Job - BOARD COUNT]
Photo of Lynne8817

Lynne8817

  • 630 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Change the field properties on the field [# ***TOTAL*** BOARDS DELIVERED] to not treat blank as null.

Then 

If(not IsNull([# ***TOTAL*** BOARDS DELIVERED]), [# ***TOTAL*** BOARDS DELIVERED]-[Order - Job - BOARD COUNT])

You will need to see where else that field [# ***TOTAL*** BOARDS DELIVERED] is being used.  If it is used in a formula or summary totals where you do want to treat blanik as zero would would need to make a formula field with
Nz([# ***TOTAL*** BOARDS DELIVERED]) to flip the blank to a zero