Add a certain percentage to currency field 1

[AuctionLamb]

Hi guys!

I have a field called mUnit_Price, how do I create another field next to it with 14% added to that field.

For example I have $10 and want to add 14% to that on my next field so my new field next to that field will show $11.40. How will I do that?

 

[MisterMo]

here is a quick way

{mUnit_Price} + (({mUnit_Price}/100)*14)

Mo

 

[MisterMo]

sorry I forgot

Create a formula field and put the following

{mUnit_Price} + (({mUnit_Price}/100)*14)

and then place the formula on your report side by side to the {mUnit_Price} field

Mo

 

[AuctionLamb]

THANKS MisterMo!!