Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

Formula Help - Return Min if no Null values present

I have 2 Min formulas where when one is Null in another formula, it returns the other value.

I need the second Min formula to only calculate when a specific date field has a value ("[End Date (Report Specific)]").


Delivery Deadline Calc1 Formula
Min ([Delivery Deadline1], [Delivery Deadline2])

Delivery Deadline Calc2 Formula
Min ([Delivery Deadline3], [Delivery Deadline4])


Report Deadline Formula
Nz([Delivery Deadline Calc2], [Delivery Deadline Calc1])

  • Is this what you want

    Delivery Deadline Calc2 Formula
    IF(not IsNull([End Date (Report Specific)],
    Min ([Delivery Deadline3], [Delivery Deadline4]))
  • Yes! Thank you! I did not realize I could use "not" in that line. That worked perfectly.