Keepchat in expression !

[#1]

Hi All,

I have a expression and with an error that I can't fix it:

=sum( {$<YEAR = {$(=MAX(YEAR))},PERIOD={KeepChar( Vcurrent,'2')}>} DOLLAR )

Could anybody tell me what's the problem with the keepchar part?

Thanks,

Nima

[MayilVahanan]

Hi,

     Before use a variable in expression itself, use keepchar function.. and use like this,

    = Sum ({<Year = { $(=Max(Year))} ,Period ={'=$(=vCurrent))'}>} DOLLAR)

     vCurrent = > KeepChar(Year,'2') something like this

Hope it helps

[#3]

That's the problem!

I have to use keepchar in expression because the Vcurrent changes based on the selection.

I want to re-use the Vcurrent for different columns, like :

PERIOD={KeepChar( Vcurrent,'3')} or

PERIOD={KeepChar( Vcurrent,'4')} and so on.

Any help is appreciated.

Thanks,

Nima

[#4]

Sorry the Doc is big and upload it

[MayilVahanan]

HI,

     Try like this,

=sum( {$<YEAR = {$(=MAX(YEAR))},

Period= {'=$(=KeepChar(Vcurrent,chr(39) &2 & chr(39)))'}>}Dollar)

Hope it helps

[#6]

Thanks, but it returns nothing in expression but it text box it's good.

kind of weird !!

[MayilVahanan]

Hi,

     Check in expression step by step.. You can find the solution..

=sum( {$<YEAR = {$(=MAX(YEAR))} >}Dollar)

=sum( {$<Period= {'=$(=KeepChar(Vcurrent,chr(39) &2 & chr(39)))'}>}Dollar)

Then combine both..You can find solution.

Hope it helps