
1. Re: Discount percentage
try67 Jan 11, 2016 1:38 PM (in response to sweetangelh)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
sweetangelh Jan 11, 2016 2:02 PM (in response to try67)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
try67 Jan 11, 2016 2:10 PM (in response to sweetangelh)Is the Discount field set as Percentage under Format?


5. Re: Discount percentage
try67 Jan 11, 2016 3:52 PM (in response to sweetangelh)Then you can use this as the Simple Field Notation formula:
MSRP1 * (1Disc1)

6. Re: Discount percentage
sweetangelh Jan 11, 2016 4:01 PM (in response to try67)So what does the (1) stand for in (1Disc1)?

7. Re: Discount percentage
try67 Jan 12, 2016 1:39 AM (in response to sweetangelh)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
gkaiseril Jan 12, 2016 1:15 PM (in response to sweetangelh)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.