Expression in script

[#1]

Hi,

   can anybody  change the given expression and give me the same in scripting part.  but  want the count of  matched and unmatched rows...

EXP:::

IF(IsNull(TRIM(Company_NM))

,If(UPPER(Trim([BU_SORT1]))<>UPPER(TRIM(LEFT([Common_NM],20))),'NO MATCH','MATCH')

   ,If(UPPER(Trim([BU_SORT1]))<>UPPER(TRIM(LEFT([Company_NM],20))),'NO MATCH','MATCH')

)

i want this to code in script  but want to rename   as matched and unmatched   with sum

like     sum(if(BU_SORT1=Common_NM),1,0)  as matched 

sum(if(BU_SORT1<>Common_NM),1,0)  as unmatched

with the given conditions

I am trying but showing  error  as:  multiple parameters..

Pls help

[jagan]

HI,

Try like this

sum(if(BU_SORT1=Common_NM,1,0))  as matched ,

sum(if(BU_SORT1<>Common_NM,1,0))  as unmatched

Regards,

Jagan.

[#3]

Try like below:

Add the Flag to yuur scipt:

if( Len(Tirm(Company_NM) ,

if( upper(Trim(BU_SORT1)) = UPPER(LEFT(TRIM(Common_NM),20)) , 1 ,1 )

,0 ) AS MatchFlag

MatchFlag have 1 for match 2 for nomatch 0 for null

UI:

Counr({<MatchFlag={1}>} DISTINCTCompany_NM) --> Match Flag count

Counr({<MatchFlag={2}>} DISTINCTCompany_NM) --> NoMatch Flag count

[#4]

I want them to show in the table box ,so dont want to do anything in the  UI side.No falgs works out

[#5]

If you need the field shows on the table box, simply convert number into text.

if( Len(Tirm(Company_NM) ,

if( upper(Trim(BU_SORT1)) = UPPER(LEFT(TRIM(Common_NM),20)) , 'Match' ,'NoMatch' )

,null() ) AS IsMatch

[#6]

Dathu,  I didn't get you. can you clear me.

[#7]

can any body help pls