except two product

[sagaraperera]

Dear All

I Already use give below script to get a last year value in my script. But in this expression include all CLA_CODE  (eg-; FR,MR,MS,TT,SS ,ect...) Then I want to get a  value of except TT and  MR CLA_CODE using with given below expression.

Please help me.

=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-10)'},DESCRIPTION= {'NRP'} >} [Budget])

sagara

[Chanty4u]

you can include the expresion below in to  your expression

CALCODE-={'VALUE1','VALUE2'}

[nagarjuna_kotha]

Try this ,

It wil exclude those both and gives for remaining.

=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-10)'},DESCRIPTION= {'NRP'},CLA_CODE  -={'TT','MR'} >} [Budget])

-Nagarjun

[sagaraperera]

Dear Mr.Nagarjun

Thanks it is work

sagara

[nagarjuna_kotha]

then kindly close this thread

-Nagarjun