Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%'),
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.
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