Expression problem

[#1]

Hi, I have this expression:

Sum({<queue={644,647} , goal_id={"<4"}>} answ_call_cnt)+Sum({<queue={644,647} , goal_id={"4"}>} answ_call_cnt)/2/(Sum({$<queue={644,647}>} answ_call_cnt)+Sum({$<queue={644,647}>} aband_call_cnt))

I want to Sum all the values <4 and then add half the values of =4 then devide it with the sum of answ_call and aband_calls.

Can you please help?

SOLVED BY USER // THANKS ANYWAY

[tresesco]

It seems more like proper parenthesis issue. Or, do you doubt something else?

[#3]

Nope, but i have tried several solutions and can't get it right 😕

[tresesco]

Try to post a sample qvw stating expected output.

[#5]

Only got private licens and im connected to a ODBC

[sunilkumarqv]

Try this

Sum({<queue={644,647} ,goal_id={“<$(=4)=$(=4)”}>}answ_call_cnt/13)/(Sum({$<queue={644,647}>} answ_call_cnt)+Sum({$<queue={644,647}>} aband_call_cnt)

[er_mohit]

Try this

if(wildmatch(queue,'644','647'),

(Sum({<goal_id={'<4'}>} answ_call_cnt)+Sum({<goal_id={'4'}>} answ_call_cnt)/2)

/

(sum(answ_call_cnt)+sum(aband_call_cnt)))

or this

(Sum({<queue={644,647} , goal_id={'<4'}>} answ_call_cnt)+

Sum({<queue={644,647} , goal_id={"4"}>} answ_call_cnt)/2)

/

(Sum({$<queue={644,647}>} answ_call_cnt) +

Sum({$<queue={644,647}>} aband_call_cnt))

[tresesco]

Private licence doesn't stop you to share a qvw. Have a look here: Preparing examples for Upload - Reduction and D... | Qlik Community