adding in an expression

[rcorcoran]

Hi I have the expression below basically I want the sum of CAMHS120=1,2 divided by the sum of (CAMHS120 =1,2 and CAMHS124=7,8,9)

The expression here doesn't work for me

num(Sum({$<[CAMHS120]={1,2},ReferredMM={1}>}ActualValue)/(Sum({$<[CAMHS120]={1,2},[CAMHS121]={7,8,9},ReferredMM={1}>}ActualValue)), '##0.0%'),

[giakoum]

looks correct. try putting single or double quotes on the values (i.e. [CAMHS120]={'1','2'}

Does any part of the expression work?

It would be great if you could post a sample app.

[Anonymous]

Hello,

Should work by all means.

Try to break down the problem.

- Get rid of num().

- Try only first expression.

- Try only second expression.

Maybe related to division by zero.

BR

Serhan