Count Expression

[khanashique]

Hi Experts,

Below count expressions which works fine:

COUNT({$<QC-={'NA'}>}DEPARTMENT)

COUNT({$<QC-={"=QC like 'NA'"}>}DEPARTMENT)

it does not work, when i add another condition to existing expression:

COUNT({$<PROD-={"=PROD like 'NA'"},QC-={"=QC like 'NA'"}>}DEPARTMENT)

COUNT({$<QC-={'NA'},PROD-={'NA'}>}DEPARTMENT)

Thanks,

MAK.

[bramkn]

try QC={"*NA*"} also for the others

[khanashique]

Hi Thanks for your quick reply,

I have tried that wild card " * " but hard luck it works only for single expression...

Thanks,

MAK

[sasiparupudi1]

Do you get correct value when you use

COUNT({$<PROD-={"=PROD like 'NA'"}>}DEPARTMENT)?

[Thiago_Justen_ · Accepted solution]

Try this out:

COUNT({$<QC-={'NA'}>+<PROD-={'NA'}>}DEPARTMENT)

[khanashique]

Yes

[khanashique]

Hi Thiago,

Thanks this works...even below can also help:

(COUNT({$<PROD-={'NA'}>}DEPARTMENT) + COUNT({$<QC-={'NA'}>}DEPARTMENT))

Thanks,

MAK.

[Thiago_Justen_]

Sound's good man. I'm happy to help you.