Simple solution to using percentage?

[anders_t]

Hi all!

I guess this is really easy, but somehow I don't seem to be able to think straight today...

First Field: a simple value. Like 100 dollars.

Second Field: a percentage value. Like 10%.

Third Field: The sum of First and Second Field.

Easy, isn't it?!! Well, at least not for me right now.

Any suggestions?

Thanks in advance

Anders

[Ender]

The units of those two things are different (dollars and percent), so they don't really add up.

Do you mean to add 10% of $100 to $100? That would be $110, or:

Dollars * (1 + PercentIncrease)

[anders_t]

Oh, sorry I wasn't clear. No, I want the sum Field to display the total of 100 dollars minus 10%, ie 90 dollars.

thanks in advance

Anders

[Tim W]

Hi Anders,

Use Dollars *(1 - percentage)

or Dollars - (Dollars * percentage)

Percentage must be converted to decimal value i.e. 10% converts to .10

Hope this helps,

Tim

[anders_t]

Yeay, that finally did it!

Thanks very much, you made my day!

Anders

[anders_t]

Well, I've bumped into a slightly more complicated (to me anyhow) dilemma.

Field 1: the number of products, let's say 2

Field 2: the cost of one product, let' say $100

Field 3: ability to set percentage - let's say 10%

In the fourth and last field I want the sum of a product, so in this case it should be $200 minus the 10%, so total sum= $180.

Right now I'm using this calculation for the SumField

Dollars - (Dollars * percentage)

but how do I fit in the number of products in this?

Any suggestions welcome

Anders

[comment]

Quantity * ListPrice * ( 1 - DiscountRate )