% is coming as 1 instead of 100%

[#1]

We have one field in the straight table few of them having different time format as (Number, Timeframe and %) . Number and timeframe  format are appearing properly however in the percentage few times when there is 100% it is showing as 1, although other values coming as 90% or 80% properly.

Can you please give some insights?

Thanks

Heeranmoy

[sunny_talwar]

Can you share a screenshot of what you are seeing?

[Chanty4u]

use Num(sum(field)) '%'

[Peter_Cammaert]

Is your percentage field a calculated field, a string field or an expression with different numerical format adjustments (e.g. using num())? Percentages are usually stored as number values between 0.0 and 1.0 (for a range from 0% to 100%). The percentage and scaling is added by a Number format selection on the Chart Properties->Numbers tab.

As a first step towards finding out why this is happening, can you add a column next to the current one that outputs the same numerical value but without the percentage formatting? And please post the expression you are using for the original column.

Best,

Peter

[jjbom1990]

Num(field),'#.##%')

This will present the value with 2 decimals, if you have no decimals you could just leave it like so:

Num(field),'%')

[#6]

I have tried all the options however it is not working:

Its coming as :

A                  B                      C

67.55%          80.67%               1

1                    78.56%               90.00%

I am using like that '#.##%'