PERCENTAGE OF BASE OUT OF TOTAL

[WPCMS]

I have a simple math question. I am trying to find out what the base price is of the total that includes a fee.
Example:
I have a total of $200.00 which includes a 6% fee. I need to break this down in my report to show the base of <$$$> and the fee of <$$$> to equal $200.00. I know this is a simple accounting formula but I completely forgot how to do this.

Thanks,

 

[Madawc]

I'd have thought {amount} * .94 would work

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[WPCMS]

Yeah, that is what I thought as well BUT! I need the original base price 6%. Not 6% of the total. Our vendor costs are the base price plus 6% of the base price. If you have $100.00 which includes 6% of fees your base price is NOT $94.00 because $94.00 plus 6% (%5.64) equals $99.64 and not the $100.00 that we have as a total. I know there is a formula to figure that out.

 

[lbass]

You would use:

{table.total}/1.06

-LB