Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I would write
Count({< TEST = {'1'}>}) NO)
Check enclosed file...
Dear ,
Find the attached file.
hope it will help you.
Thanks,
Mukram