Forum Discussion
MarkShnier__You
4 years agoQrew Legend
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
------------------------------
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([
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------