connecting expression

[sagaraperera]

Dear All

I try to get a last year figure in my script given using given below expressins

sum( {$<TRAN_YEAR= {"$(=Only([TRAN_YEAR]-1))"}>} [Actual]) 

It is 100% work,

But i want to hard cord get a figure only GROSS_PREMIUM. I use get a current year GROSS_PREMIUM given below expression

Sum ( {$<DESCRIPTION= {'GROSS_PREMIUM'} >}[Actual])  

I WANT CONECT ABOVE TWO EXPRESSION AND GET A LAST YEAR  GROSS_PREMIUM ONLY.

Please help me.

Sagara

[Chanty4u]

=sum( {$<TRAN_YEAR= {"$(=Only([TRAN_YEAR]-1))"} and DESCRIPTION= {'GROSS_PREMIUM'} >} [Actual]) )

[tresB]

sum( {$<DESCRIPTION= {'GROSS_PREMIUM'}, TRAN_YEAR= {"$(=Only([TRAN_YEAR])-1)"}>} [Actual])

[tresB]

Your 'and' is improper here. It should be replaced by a comma (,).

[Anonymous]

may be like this?

=sum( {<TRAN_YEAR= {'$(=Only([TRAN_YEAR]-1))'},DESCRIPTION= {'GROSS_PREMIUM'}>} [Actual])

or

=sum( {<TRAN_YEAR= {'$(=max([TRAN_YEAR])-1)'},DESCRIPTION= {'GROSS_PREMIUM'}>} [Actual])

and check this as well, helpful for you?

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

[Anonymous]

sum( {$<DESCRIPTION= {'GROSS_PREMIUM'}, TRAN_YEAR= {"$(=Only([TRAN_YEAR]-1))"}>} [Actual])

[Digvijay_Singh]

Just wanted to know the use of 'only' here, I think its not making sense here, may be  I am missing something..

[Anonymous]

sum( {<TRAN_YEAR= {'$(=Only([TRAN_YEAR])-1)'},DESCRIPTION= {'GROSS_PREMIUM'}>} [Actual])

-1 is given the outside of the braces

[tresB]

Yes it would even work similarly without the function only(). It's that - to tell explicitly that the expression would work only on - single value selection of Year field TRAN_YEAR.

[#10]

Hi

PLEASE TRY THIS EXPRESSION.

sum( {$<TRAN_YEAR= {'$(=max([TRAN_YEAR])-1)'}, DESCRIPTION ={'GROSS_PREMIUM'}>} [Actual])