using greater than and less than in expression

[rcorcoran]

Hi I have this expression and want to show it as sum of CAMHS124 where it is >=7 or <=26

any help would be great

Thanks

num((((Sum({$<[CAMHS124]={7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,},ReferredMM={1}>}ActualValue)))), '##0'),

[tresesco · Accepted solution]

Try like:

....<[CAMHS124]={">=7 <=26"}..

[sagarkharpude]

Try this

=sum({<[CAMHS124] = {">=7<=26"},ReferredMM={1}>} ActualValue)

[rcorcoran]

Thanks so much for your help both right.

Rhona

[rcorcoran]

Thanks you sagar that works fine

[rcorcoran]

Than you again tresesco that works great

Rhona