Pivot table values shows 000-127

[Senthil4you]

I have created a pivot table in Qlik desktop and its more like P&l statements, most of the lines comes in correctly with respectives values only component relates to Profits and employee data shows as 000-157, which means my desired answer is 157 but its showing with prefix as 000 not sure, this is happening only in few lines. not all the lines in the tables. not sure why any advise please. number formatting is kept in number and its shown with 1 decimal point

[rubenmarin]

Hi, when data is showed left aligned it means that is being loaded as a text, not as a number, try with Num#() and Num() funtions to convert it to number.

If it shows a '-' it would be beacuse the source thas the data like that, check that values, maybe you need some additional transformations to recover the number you want.

It can end with something like:

=Num(Num#(Mid(NumberField,Index(NumberField,'-')+1),'0,0','.',','))