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
Num(Num#(units * selling price))
Normally, Qlik calculates over dimension with aggregate, Perhaps this way
Num(Num#(Sum(units * selling price)))
Can you please share sample Qlik file which demonstrate quicker for you?