Great community here guys, so thanks in advance.
I buy real estate and I need assistance on a "calculations" field.
This App allows me to put in 3 values "manually" - the: ARV, CMV and DMV (money fields)
Then muliply one of those selections by a "catagory" field called/labeled "discount"
Finally there are times when I deduct the repairs and there are times when I don't.
So therfore I have a "category" field called labeld "repairs" with a simple Yes/No.
In math terms this looks like: ARV X .70 - Repairs = Our Offer
I'll add in other deductions later but what should this code look like?
This is what I have there now:
You'll notice right not this simply does: Offertype x DISCOUNT = Offer
However this is not a great function as the ARV and CMV are "hard coded" and the new version will allow us to select "Base Factor"
All I have to do is create a catagory and put ARV, CMV and DMV then reference those Money fields which when the calculation happens it will see which catagory is selected.
I hope that makes sense as I'm having to add fields and change the calculations as I add in things hense why i need help.
Good part is if you get it working once I can add everything else in.
(see photo) - https://www.dropbox.com/s/24enxk16entexyt/Screenshot%202018-01-18%2019.14.54.png?dl=0