Need Help-if

[dhanu_today]

Hi Everyone,

I have to get the count of NO'S where PM_CODE  is not equal to ‘ABB10’  under the PC_CODE

902,954,956.

I have to get the cont of NO's under the above mentioned PC_CODES with PM_CODE is not equal to 'ABB10'.

The following expressions i have written in the script level.

If(wildmatch(PC_CODE,’902’,’954’,’956’) and not wildmatch(PM_CODE,’ABB10’),1,O) AS TEST

In fornt end level ;

Region (as Dimension)           Expression

In the expression I have written like this;

Count({<No = p({<  TEST = {'1'}>})  >} Distinct NO)

plz correct the above logic.

Thanks in adv,

Dhanu

[alexandros17]

I would write

Count({<  TEST = {'1'}>}) NO)

[MK_QSL]

Check enclosed file...

[mdmukramali]

Dear ,

Find the attached file.

hope it will help you.

Thanks,

Mukram