## Using discounts (%) in formulas.

## Using discounts (%) in formulas.

(OP)

Good day to all,

I'm trying to calculate the price of an article applying a discount (%), i.e:

"Regular Price" - "Discount (%)" = "Price with discount"

I'm aware that it's not possible to use the discount value (x%)directly so I've come up with the following formula:

({Regular Price}-({Regular Price}*

However, when the discount is 0 (zero) the result of this last step is also 0(zero), resulting of the multiplication. Now, this is not what I'm looking for since the "regular price with a 0% (zero) discount should be exactly the same!

I appreciate all the help.

Thank you in advance

I'm trying to calculate the price of an article applying a discount (%), i.e:

"Regular Price" - "Discount (%)" = "Price with discount"

I'm aware that it's not possible to use the discount value (x%)directly so I've come up with the following formula:

({Regular Price}-({Regular Price}*

__({Discount}/100))__However, when the discount is 0 (zero) the result of this last step is also 0(zero), resulting of the multiplication. Now, this is not what I'm looking for since the "regular price with a 0% (zero) discount should be exactly the same!

I appreciate all the help.

Thank you in advance

## RE: Using discounts (%) in formulas.

{table.price}-({table.price}*{table.discount}/100)

-LB

## RE: Using discounts (%) in formulas.

Or change formula to test for null replace discount field with formula

@discount

if isnull(discount) then 0 else discount

Ian