Conditional Expression:

[EBabalola]

Hello All

Please I need help with this expression

if(ValueList('[Is Patient on a St]', 'No')='No', Count({<[Chol range]={'5.1 - 6 mmol/L'}>}[Chol range]))

I have tried that to get only the Chol Range where Is Patient on a St is No.....It did not work

[MayilVahanan · Accepted solution]

Hi @EBabalola 

is [Is Patient on a St] field?? if so, try like below

Count({<[Chol range]={'5.1 - 6 mmol/L'}, [Is Patient on a St] = {'No'}>}[Chol range])

[EBabalola]

Thank you so Much.....It is 100% perfect.

[MayilVahanan]

HI @EBabalola 

Can you close the thread by marking correct answer.