Format for % in a concatenated field

[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

 

[JE McGimpsey]

One way:

="30 =" & TEXT(30/Count([surname]), "0.00%")

 

[Peo Sjoblom]

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%")

 

[JE McGimpsey]

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.

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%")

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

 

[Peo Sjoblom]

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)

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.

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%")

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

 

[Robin Chapple]

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.

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%")

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