How to filter out data from a certain Group Name field?

[Former Member]

Hi All,

I am trying to filter out data from a certain group level field from my report but I am not sure where and how should i use this formula.

I tried to include the following formula in the Record Selection formula editor but it keeps giving me an error.

Formula:

Not {NAME} Like "AMBULATORY*"

Error:

A boolean is required here.

Any help is greatly appreciated.

[abhilash_kumar · Accepted solution]

Hi Nimish,

Try

Not({Name} LIKE 'AMBULATORY*')

-Abhilash

[Former Member · Accepted solution]

Thank you, This formula worked as desired.