How can I create a formula to take greater of award value or modified value - cost.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I need to create a formula that should give me profit.

I have award value and modified award value(sometimes we go back o=to the customer for change of price)

The formula needs to be Greater of Award Value or Modifeid award value minus total cost .

Can someone please help...


Thanks

Photo of Neal

Neal

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
no problem

Max([award value], [modified award value])