Need Help-if

dhanu_today — Tue, 22 Apr 2014 07:59:12 GMT

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

Re: Need Help-if

alexandros17 — Tue, 22 Apr 2014 08:02:25 GMT

I would write

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

MK_QSL — Tue, 22 Apr 2014 08:20:30 GMT

Check enclosed file...

mdmukramali — Tue, 22 Apr 2014 08:26:34 GMT

Dear ,

Find the attached file.

hope it will help you.

Thanks,

Mukram