Number formatting issue

[OmarBenSalem]

Hi ALL,

I have a 2 fields as follow:

I want to transform them to percentage %:

so, this is how I proceed:

but I still have the same result:

num(num#( [Notional_Variation],'#.##') ,'# ##0,00%') AS [Notional_Variation],

num(num#( [Threshold_Variation],'#.##') ,'# ##0,00%') AS [Threshold_Variation],

What should I do?

[zebhashmi]

Can you store Data in % in Table?

I would say /100 and Add &'%' but that would be string

[OmarBenSalem]

even with that, u'll have the same behaviour

[OmarBenSalem]

hell yeah !!

Now I remember !!

I've already faced this: