Number format

[OmarBenSalem]

Hi folks,

I'm trying to format my numbers in the SCRIPT.

here's how they're now:

and I want them to be as follow:

For that, I've done as follow:

num(Current_Notional,'# ##0') as Current_Notional,

and

num(num#(Current_Notional),'# ##0') as Current_Notional,

But, this did not change a thing !

What am I doing wrong?

[Chanty4u]

do you want round the values?

result is different than actual?

[OmarBenSalem]

Ah ; it's not the same cells / values! It's just an example of the format I want to achieve..

sorry for the confusion !

[Chanty4u · Accepted solution]

try this

Num#( Field, '#', ' ', ' ') as Result

[mdmukramali]

Hi Omar,

Can you Try something like this:

Load *,

PurgeChar(Number,',') as Test,

Num(PurgeChar(Number,','),'# ##0','.',' ') as Test2

inline

[

Number

"5575226851,9277"

"5017367203,3098"

]

Thanks,

Mukram.

[Chanty4u]

or try this

a:load  * Inline [

Categ ,Year,Sales

Car,2014,"100677884,122"

];

result:

LOAD *

,

replace(Sales,',',' ') as new

Resident a;

[OmarBenSalem]

This did not work

[OmarBenSalem]

That was perfect !

[OmarBenSalem]

This nearly worked when there is number as follow 444,22 (with ',') but with numbers without , exp: 44444; it did not !

Thank you anyway !

[Chanty4u]

Nice your issue resolved .