Sum Field have text and number format

[Anonymous]

Hello to all of you,

i have a question. I'm import a SharePoint list. I have a German System in my QliKView with the default variables. I maked a Num# on the sum fields and then i get something like this:

NUM#(Umsatz_Jan)  as Umsatz_Jan,

All Numbers with a minus before or the number with an comma are text formatted and the other all correct with number format. How can i get them together so that in the script all are a number? Thank you for your help.

Kind Regards

[arulsettu]

try this

text(NUM#(Umsatz_Jan)) as Umsatz_Jan,

[Anonymous]

try this Expression and you may put a num around to Format to your requirements

num#(PurgeChar(Umsatz_Jan,',.'))

[Anonymous]

Hello,

thank you for your help. I tried both solution. Here the result:

The resut from settu keep the format, that is ok. But i want that all of them are numbers,  so they should be on the right sight. I don't know how to realize this in the script. Maybe you have also an idea?

Kind Regards

[Anonymous]

Now i only need this as number.

[Anonymous]

as I wrote you may use num function

=num(num#(PurgeChar(Umsatz_Jan,',.')),'#.##0')