Format for % in a concatenated field

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a calculated field in a report that includes a percentage.

="30 =" & (30/(Count([surname]))*100) & "%"

How do I format the percentage to two decimal places?

Thanks,

Robin Chapple
 
I would use



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

Why the *100?
to get the percentage use
something like

="30 =" &TEXT(ROUND(30/COUNT(whatever),2),"0.00%")
 
Rounding to 2 decimal places will cause 0.12345 to display as

12.00%

TEXT automatically rounds, so if the OP's desire was to have the
percentage display as

12.35%

then TEXT(30/COUNT(...),"0.00%") will do that.

Peo Sjoblom said:
I would use



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

Why the *100?
to get the percentage use
something like

="30 =" &TEXT(ROUND(30/COUNT(whatever),2),"0.00%")



Robin Chapple said:
I have a calculated field in a report that includes a percentage.

="30 =" & (30/(Count([surname]))*100) & "%"

How do I format the percentage to two decimal places?

Thanks,

Robin Chapple
Click to expand...
Click to expand...
 
You are right, thought process wasn't working.

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



JE McGimpsey said:
Rounding to 2 decimal places will cause 0.12345 to display as

12.00%

TEXT automatically rounds, so if the OP's desire was to have the
percentage display as

12.35%

then TEXT(30/COUNT(...),"0.00%") will do that.

Peo Sjoblom said:
I would use



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

Why the *100?
to get the percentage use
something like

="30 =" &TEXT(ROUND(30/COUNT(whatever),2),"0.00%")



Robin Chapple said:
I have a calculated field in a report that includes a percentage.

="30 =" & (30/(Count([surname]))*100) & "%"

How do I format the percentage to two decimal places?

Thanks,

Robin Chapple
Click to expand...
Click to expand...
Click to expand...
 
Thanks Peo,

Appreciated.

Robin Chapple

Rounding to 2 decimal places will cause 0.12345 to display as

12.00%

TEXT automatically rounds, so if the OP's desire was to have the
percentage display as

12.35%

then TEXT(30/COUNT(...),"0.00%") will do that.

Peo Sjoblom said:
I would use



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

Why the *100?
to get the percentage use
something like

="30 =" &TEXT(ROUND(30/COUNT(whatever),2),"0.00%")



Robin Chapple said:
I have a calculated field in a report that includes a percentage.

="30 =" & (30/(Count([surname]))*100) & "%"

How do I format the percentage to two decimal places?

Thanks,

Robin Chapple
Click to expand...
Click to expand...
Click to expand...
 
Back
Top