% calculated but not to two decimals

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

I have a very simple calculation
Percent = (i/j) *100
That works, but it doesn't expand to two decimals.

I want it to be something like 99.38%

How can I change the equation above to do that?

Thanks

Ben
 
Ben assuming its a control open properties for the control
Set Field size to decimal
Format to % or fixed depending on how the formula works
Precision 4 or 6 ( F1 for more info on this)
Scale 2
Decimal places 2

in the properties box select a property and hit F1 and a great description
of what the property does will be dispayed.

Cheers
 
I have a very simple calculation
Percent = (i/j) *100
That works, but it doesn't expand to two decimals.

I want it to be something like 99.38%

How can I change the equation above to do that?

Thanks

Ben
Click to expand...
How about....

=Format((i/j)*100,"#.00")
 
Back
Top