Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Percentages issues

Avatar

Level 4

Hi, I have created a form in Adobe LiveCycle 8, and it has a lot of calculations.  I have a couple of questions regarding this.  I am using the FormsCal.  Here is the first calculation:

 

 

 

= DerivationofCostProposal.Table3.Row1.TotalLabor * DerivationofCostProposal.Table3.Row1.TotalPercentage

What I need here is to be able to put 25% in this field "DerivationofCostProposal.Table3.Row1.TotalPercentage" and then have it calculate in the Total Column.

Is there a way to be able to put 25% in the field and make it calculate rather than .25?  Right now I have the field as a Numeric Field.  Regardless of how I put the percentage in (25% or .25) I need the same field to not round up or down, but display the actual number entered.  Right now, if I use .25, it enters as a "0".  Is there a way to do this?

1 Reply

Avatar

Level 10

Hi,

create a numeric field and set its data format to integer.

Then add the display pattern num{zz9 '%'}.

When you calculate you need to transform the integer value:

DerivationofCostProposal.Table3.Row1.TotalLabor * (1 / 100 * DerivationofCostProposal.Table3.Row1.TotalPercentage)