5 Replies Latest reply: Jul 12, 2016 6:50 AM by Rudolf Linder RSS

    Sum Field have text and number format

    Daniela Port

      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,

       

      text.JPG

       

      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