Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum if not working

Untitled.png

You see the picture above. Turnover is calculated by using this expression:

sum(If(IsNull(sub_exec_broker),trade_price*traded_amount)) <- Works fine!

Then I just want to convert it to EUR in a second column by just adding:

sum(If(IsNull(sub_exec_broker),trade_price*traded_amount/rate_eur))


And this makes it not working. Any suggestions?

4 Replies
sunny_talwar

Can you try this:

Sum(If(IsNull(sub_exec_broker),trade_price*traded_amount))/rate_eur

Not applicable
Author

Not working, null values

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi

Try this,

sum(If(IsNull(sub_exec_broker),(trade_price*traded_amount)/rate_eur))


Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
hic
Former Employee
Former Employee

This should work. So my guess is that "rate_eur" does not have a numeric interpretation.

Try IsNum(rate_eur) in a list box just to see what you get...

HIC