AnsweredAssumed Answered

How to achieve this calculation?

Question asked by BorisKamp on Sep 7, 2013
Latest reply on Oct 12, 2013 by BorisKamp

Title

How to achieve this calculation?

Post

     hi!

     In our property database we would like to keep track of rehab budgets and final rehab costs.

     We would like these outcomes:

         
  1.           Under budget (if final rehab costs are >10% under budgeted costs) (example: buget $4000 Final costs $3000)
  2.      
  3.           Budget (if final rehab costs are  within 10% of the budgeted costs) (example: buget $4000 Final costs $4200 or 3800)
  4.      
  5.           Over budget (if final rehab costs are >10% over budgeted costs) (example: buget $4000 Final costs $5300)

      

     We would like the the texts "Under Budget" "Budget" "Over Budget" to appear depending on the outcome of the calculation.

      

     I cant seem to figure this out so any help or links to documentation about this is very welcome.

      

     Thanks guys!

Outcomes