Range

[janardhan]

Hi Friends ,

if any one can give me an idea about this ,

i need sum in between OTG50 to OTG175 , for that i tried like this. its wrong expression. cany anyone help me

=RANGESUM(IF(ITEMID>='OTG50' - ITEMID<='OTG175' , LINEAMOUNT))

Thanks

jana

[Anonymous]

hi u can use

sum( {$<ITEMID= {“>=OTG50<=OTG175”}>} LINEAMOUNT)

hope it workz

regardz,

Vaibhav

[janardhan]

Hi vibhav,

i am getting error msg like : Error in set modifier ad hoc element list

[Anonymous]

HI

Chk d Attached app

[janardhan]

Hi can any one tell me this expression is correct

shall i write like this

=

sum(if(ITEMID>='OTG050'and ITEMID<='OTG175',LINEAMOUNT) +
if(ITEMID>='OTG182'and ITEMID<='OTG192' , LINEAMOUNT) +
if(ITEMID>='OTG193'and ITEMID<='OTG196' , LINEAMOUNT))

[jagan]

Hi Janardhan,

It is much easier if you arrive a new field which holds numeric value from string

Ex: OTG050 as 50 in new field

LOAD

     ITEMID,

     Right(ITEMID) AS NewITEMID

FROM DataSource;

So now in your expression you can use straight away

=sum(if(NewITEMID>=50 and NewITEMID <=175,LINEAMOUNT) +
if(NewITEMID>=182and NewITEMID<=192 , LINEAMOUNT) +
if(NewITEMID>=193 andNewITEMID<=196 , LINEAMOUNT))

Hope this helps you.

Regards,

Jagan.

[janardhan]

Thanks for ur help , i have already done.