Different data formats in same column

[dseelam]

Hello All,

I am trying to achieve  units * selling price as total amount seems its working fine for selling price 17.99 which is a text  format but not working for 7.22 showing as $0, Not sure what to do used num(), num#() not working please help.

Sorce data format

Thanks,

D

[Anil_Babu_Samineni]

Perhaps this?

Num(Num#(units * selling price))

Normally, Qlik calculates over dimension with aggregate, Perhaps this way

Num(Num#(Sum(units * selling price)))

[dseelam]

Hello Anil, Thanks for reply,

But above solutions did not helps 

Thanks,

D

[Anil_Babu_Samineni]

Can you please share sample Qlik file which demonstrate quicker for you?

[Vegar · Accepted solution]

Try wrapping a trim() around selling price. Sometimes that helps if there are some invisible whitespace in the source data. 

Trim(SELLING_PRICE) AS [Selling Price] 

[dseelam]

Thank you Vegar