Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you can include the expresion below in to your expression
CALCODE-={'VALUE1','VALUE2'}
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
Dear Mr.Nagarjun
Thanks it is work
sagara
then kindly close this thread
-Nagarjun