Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi u can use
sum( {$<ITEMID= {“>=OTG50<=OTG175”}>} LINEAMOUNT)
hope it workz
regardz,
Vaibhav
Hi vibhav,
i am getting error msg like : Error in set modifier ad hoc element list
HI
Chk d Attached app
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))
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.
Thanks for ur help , i have already done.