Percentage symbol for Pre Calculated Measure

[Prudhviraj]

Hi ALL,

We have a column which has been pre caluclated in database itslef. for one code I'm getting value as 42.57. But I want to see same value as 42.57%.

When I change the foramt as Percentage, value is changing to 4257.00 % , but I don't want that to happen. How should I get my value with percentage symbol.

Could you please help me out on this, Quick reply would be really appreciable.

Thanks,

Prudviraj

[Vvelarde · Accepted solution]

@Prudhviraj

Hi, In a new calculated column Divide by 100 and change the format to percentage.

Also you can do this in Query Editor.

Regards

Victor

[pxg08680 · Accepted solution]

@Prudhviraj

You can divide the existing column by 100 as told by @Vvelarde and use the percentage for newly calculated column or else do the same in your database and directly you can use the percentage over here.

[Vvelarde · Accepted solution]

@Prudhviraj

Hi, In a new calculated column Divide by 100 and change the format to percentage.

Also you can do this in Query Editor.

Regards

Victor

[Prudhviraj]

Thank you, It worked.