Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Can you store Data in % in Table?
I would say /100 and Add &'%' but that would be string
even with that, u'll have the same behaviour
hell yeah !!
Now I remember !!
I've already faced this: