How to sum with a variable

[#1]

hi, so I created a variable in settings and now I want to use this variable when summing up things.

Variable: Turnover

trade_price*traded_amount

Expression:

sum(If(IsNull(sub_exec_broker),Turnover))

[#2]

sum(If(IsNull(sub_exec_broker),$(Turnover)))

[its_anandrjs]

Try with

sum(If(IsNull(sub_exec_broker), $( Turnover ) ))

Regards

Anand

[florentina_doga]

try this

sum(If(IsNull(sub_exec_broker),$(Turnover)))

[its_anandrjs]

Update:- When create the variable Turnover do not use = sign above the fields

Ex:-

Let Turnover = 'trade_price*traded_amount';

And expression will be =sum( $(Turnover) )

Regards,

Anand

[#6]

Not Working. Should I change anything to the defintiion of the variable?

[#7]

Sorry doesnt give me anything

[#8]

Doesnt sum i jsut get 0 as value

[its_anandrjs]

Create variable like

Let Turnover = 'trade_price*traded_amount';

Your Expression:-

sum( If ( IsNull( sub_exec_broker ) = -1, $(Turnover) ) )

Hope this works

Regards

Anand

[#10]

I appreciate your effort, but it doesnt work I get 0 as value I have made the LET step and use your expression.