Combine Count function with a selection and a IF statement

[andymanu]

Hi All,

Could someone please help me to combine the below specified functions into a one.

I got a function with "COUNT" as,  "=Count({<PASID={'*'}>}UNIQUE_SCHEDULES)"

Also I want to filter the above data using a flag which is, "FLAG_Prof_Carer_Type".

I tried as , "Count(IF(FLAG_Prof_Carer_Type=1,Count({<PASID={'*'}>}UNIQUE_SCHEDULES)))"  but it is not giving me the results,

Note

field "UNIQUE_SCHEDULES" is a combined field use to filter unique set of data rows. Also, I am using the combined function in a Gauge to represent a percentage.

Appreciate your valuable feedback.

Kind regards,

Andy

[vishsaggi · Accepted solution]

May be you want to write like this?

= Count({< FLAG_Prof_Carer_Type = {1}, PASID={"*"} >} UNIQUE_SCHEDULES)

[andymanu]

Hi Vishsaggi,
Thank you very much. It's working.
However, when I merge it to the Gauge, it's not showing the expected results.
I'll add detail data shortly may be with the QVF file.
Kind regards,
Andy