Multiple Format in Calculated Text Box

  • Thread starter Thread starter PPCO
  • Start date Start date
P

PPCO

I have the following expression in a calculated text box on a report:

=[NumberofGoalsReached] & "/" & [TotalNumberofGoals] & "=" &
Format([GoalPercentage],"Percent")

I would like to add a decimal format to the [GoalPercentage] part of the
statement in addition to the percent format. So it will read like this:

5/10=50% instead of 5/10=50.00% as it does now. Thank you!
 
Back
Top