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

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)

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

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

Yeay, that finally did it!

Thanks very much, you made my day!

Anders

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

Quantity * ListPrice * ( 1 - DiscountRate )