Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Can you try this:
Sum(If(IsNull(sub_exec_broker),trade_price*traded_amount))/rate_eur
Not working, null values
Hi
Try this,
sum(If(IsNull(sub_exec_broker),(trade_price*traded_amount)/rate_eur))
Regards,
Kaushik Solanki
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