Skip to main content
Known Participant
July 7, 2020
Answered

Formula to calculate discount in DC

  • July 7, 2020
  • 1 reply
  • 1893 views

Hi, I'm trying to do the following calculation: Quanity*Price - discount%. What is the formula I should use?
I'm really new to acrobat and I can't understand yet how does difficult calculations works. 

 

This is the table I'm willing to fullfill.

Thank U in advance!

This topic has been closed for replies.
Correct answer Bernd Alheit

Ok now it's working. BUT there is a probelm, what I see in the Total value field is not the Price*quantity- discount. I see the amount which I would subtract from the unit price with a perticular percentage of discount.

For example here under Total Value I se 3.090,00 which is not the total value-discount. But is the amount of discount. I should see 12.360,00 €


Use something like this:

Quantity * Price * (100-Discount)/100

1 reply

try67
Community Expert
Community Expert
July 7, 2020

What sort of values do your discount fields have? 0 - 100? 0 - 1? Something else?

Known Participant
July 8, 2020

Discount might be from 0% to 100%

try67
Community Expert
Community Expert
July 8, 2020

Then you can use this simple formula:

 

Quantity * Price * (Discount/100)

 

Use the actual names of the fields in your file, of course.