8 Replies Latest reply on Jan 12, 2016 1:15 PM by gkaiseril

# Discount percentage

I am new to this Java in the simplified notion and I am wanting to create a formula for a form that calculates the discount that is entered in from when the form User enters the discount in "Disc1" and the "MSRP1". I currently have it set up to give me the answer for that. Now I need it to minus that answer from the "MSRP1".

• ###### 1. Re: Discount percentage

It's not clear what you're deducting there... Shouldn't just UC1 be the produce of Disc1 and MSRP1, ie the price after the discount?

• ###### 2. Re: Discount percentage

This is the information that the form user will fill out "Form User":

Dealer Discount (Disc1)="44%"

Unit MSRP (MSRP1)="\$5599.00"

Currently the form is doing: 44%*\$5599=\$2464

I need to know minus the \$2464 from the \$5599 to get the answer for UC1

• ###### 3. Re: Discount percentage

Is the Discount field set as Percentage under Format?

• ###### 4. Re: Discount percentage

Yes it is

• ###### 5. Re: Discount percentage

Then you can use this as the Simple Field Notation formula:

MSRP1 * (1-Disc1)

• ###### 6. Re: Discount percentage

So what does the (1) stand for in (1-Disc1)?

• ###### 7. Re: Discount percentage

It doesn't stand for anything. It's just the number one... The value of a percentage field is between 0 (0%) and 1 (100%). So if you want to show the result after applying the discount then you need to multiply the amount by its complementary value, ie, 1 minus the discount value.

• ###### 8. Re: Discount percentage

It appears you want the expression to read:

MSSRP - (MSRP * Discount)

Which could also be written as:

(1 * MSRP) - (MSRP * Discount)

And applying the Associative Law of Multiplication becomes:

MSRP * (1 - Discount)

Compute out the discounted price both ways and the result should be the same.