Discussions

Expand all | Collapse all

Formula- Need Negative Values Returned as 0

  • 1.  Formula- Need Negative Values Returned as 0

    Posted 14 days ago
    Edited by Jeremy Silvia 14 days ago


  • 2.  RE: Formula- Need Negative Values Returned as 0

    Posted 14 days ago
    Try this

    Max(0,
    [Related Rate4 - Per Diem (Days Not Worked)]-[Related Rate4 - Per Diem (Days Worked)])

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------