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:
- Under budget (if final rehab costs are >10% under budgeted costs) (example: buget $4000 Final costs $3000)
- Budget (if final rehab costs are within 10% of the budgeted costs) (example: buget $4000 Final costs $4200 or 3800)
- 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!
Your preceding post dated September 19, indicated what you did, but did not tell me that this was still not working for you.
In reviewing this thread, it doesn't appear that you are using the correct calculation as the most recent example of what you are using does not match what I suggested:
Let ( [ Pct = ( Properties::Budget - Properties::Amount ) / Properties::Budget ;
Lim = ESR::Pct
] ;
Case ( Pct > Lim ; "Under " ;
Pct < (-1*Lim) ; "Over "
)
) & "Budget"
While I haven't checked the math carefully, the relationships do seem to return the correct values as shown in this demo file: https://dl.dropboxusercontent.com/u/78737945/RealEstateDemo.fmp12