These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Problem with Calculating with Percentage

Forum Index > Forms: LiveCycle Designer > Problem with Calculating with Percentage
2008-08-06 05:40:58
tsiebert
Registered: Jul 8 2008
Posts: 8

I have the following and the data will just be a sample:

ListPrice: 25675.00
UnitCost: 16688.75
SteelSurcharge: 3836.00
MarkupPercentage: Should be 25,655.93 but i keep getting the wrong Number. it keeps coming up with a higher number. My formacalc equation is below:

if (TotalSurcharge >0) then TotalSurcharge +UnitCost/1-MarkupPercentage else UnitCost/1-MarkupPercentage Endif.

All works fine with formula up until the markup percentage comes into play with the surcharge. Need help.

I found my answer I was missing () around a set of calcs:

if (TotalSurcharge >0) then (TotalSurcharge +UnitCost)/(1-MarkupPercentage) else UnitCost/1-MarkupPercentage Endif

My Product Information:
LiveCycle Designer, Windows
Top
2008-08-06 08:07:36
#1
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4308
What number are you getting?

This could be a big hint to the cause of the problem.

If it is off by 100 times the expected value, you will need to divide the MarkupPercentage by 100 to get the decimal value of the percentage.

If the value is the value expected from the previous entry, the field calculation order may need to be changed.

George Kaiser

Top