Different format in field

[#1]

Hi everyone,

Is there a way to have different number format on the same field like on the picture below.

What I want is PBT MARGIN and PAT MARGIN to have format in percent like '#.###%' and all other value to have format like '##.###'.

Should I solve this in script or I can manage this in chart.

Hope you can help me.

[PrashantSangle]

Hi,

Yes you can do,

In expression you can write

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

Regards,

[preminqlik]

if(dimension='PAT MARGIN' or dimension='PBT Margin',

num([percentage expression,'#,###%'),

num(sum(Amount),'##.###'))

[Clever_Anjos · Accepted solution]

There´re two or more ways, PFA an example