Forum Discussion

StephenAnguiano's avatar
StephenAnguiano
Qrew Cadet
4 years ago

Using Max in a If statement

I'm trying to set a max payout amount for my contractors and set the max amount at $3K. The following IF statement is still not working. My current data show the equipment - nominaltonnage to be 5 with a payout of $3750. 

If([Customer - Related Client]=20 and ([Measure]="Replace On Burnout" or [Measure]="New Construction") and [MeasureDate]>=Date(2020,1,1) and [Equipment - SEERrange]>=18 and [Equipment - AC or Heat Pump]="GeoThermal",Max([Equipment - NominalTonnage]*750,3000))

Thanks
Stephen

------------------------------
Stephen Anguiano
------------------------------

2 Replies

  • Try his

    MIN(
    If([Customer - Related Client]=20 and ([Measure]="Replace On Burnout" or [Measure]="New Construction") and [MeasureDate]>=Date(2020,1,1) and [Equipment - SEERrange]>=18 and [Equipment - AC or Heat Pump]="GeoThermal",Max([Equipment - NominalTonnage]*750),3000)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • AustinK's avatar
    AustinK
    Qrew Commander
    Can you describe more about what is not working here?

    What field type is the formula field?

    What field type is [Equipment - NominalTonnage]?

    I see Mark beat me to it but my thoughts were there was a difference in types among what you are trying to Max in there.