Discussions

Expand all | Collapse all

Formula Help - Return Min if no Null values present

  • 1.  Formula Help - Return Min if no Null values present

    Top
    Contributor
    Posted 10-31-2018 22:51
    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])



  • 2.  RE: Formula Help - Return Min if no Null values present

    Posted 10-31-2018 22:54
    Is this what you want

    Delivery Deadline Calc2 Formula
    IF(not IsNull([End Date (Report Specific)],
    Min ([Delivery Deadline3], [Delivery Deadline4]))


  • 3.  RE: Formula Help - Return Min if no Null values present

    Top
    Contributor
    Posted 10-31-2018 23:08
    Yes! Thank you! I did not realize I could use "not" in that line. That worked perfectly.


  • 4.  RE: Formula Help - Return Min if no Null values present

    Posted 10-31-2018 23:08
    not" a problem, my pleasure.