Solved - Help with a formula
I am trying to build a formula and it's coming out with the wrong numbers. I am trying to replicate an excel spreadsheet. The formula they have is Total for this 8111.59 I have a numerical fi...
Forum Discussion
What I did was made a separate Numerical field called Closing Tax- and I also separated the percentage for commission for Company - it was Purchase Price *33 but I decided in case that number changes to make a separate field
I had to split every thing up – as you can see until I add everything up the numbers are correct
Closing- 775.00
Closing/IVA -668.10
Percentage .33 – 7443.49
Should add up right
Then I take all those and add them up in Company Comm Total [Commission For Company]+[Closing Cost minus 400/2]+[Closing -400/2-IVA]
And it pukes - it's like it does not like all those formulas in one or do I need some kind of [ } on there?
Should it be Commission or Purchase price?
"add them up in Company Comm Total [Commission For Company]+[Closing Cost minus 400/2]+[Closing -400/2-IVA]"
Seeing your fields, this is how I would construct:
( [Purchase price for reports] * [Percentage for company] ) + ( [Closing cost minus 400/2] / [IVA of closing] )
(22,556.03 * 0.33) + (775 / 1.160) = 8,111.59
Q: Percentage for company is showing as currency - is this truly what you want?