Calculating a discount in Crystal Formula

I have a price field that I want to use minus a discount

{PRICING.BVRTLPRICE01} - {?Discount %}

{?Discount %} is my parameter which can be from 1-100

This is what I need
If {PRICING.BVRTLPRICE01} = 0.00 then 0.00 else {PRICING.BVRTLPRICE01} - {?Discount %}
LVL 1
GerhardpetAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ido MilletConnect With a Mentor Professor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
That means the % is not stored as %.

So use
{PRICING.BVRTLPRICE01} * (1 - {?Discount %}/100)
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
{PRICING.BVRTLPRICE01} * (1 - {?Discount %})
0
 
GerhardpetAuthor Commented:
The formula does not work.

Here is a sample I did
60 * (1-50) = 2940 but that should be 30

60 - 50% = 30
0
 
GerhardpetAuthor Commented:
That worked. Thanks Ido!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.