String replacement with variable

[#1]

Hi,

How is it possible that I have some results with :

Sum({<NOM_PERIODE={'20160412-0025-24 chauffe'}>}VALEUR_METRIQUE))

but when I put the string '20160412-0025-24 chauffe' in a variable SELECTION I don't have any result with :

Sum({<NOM_PERIODE={$(SELECTION)}>}VALEUR_METRIQUE))

Am I missing something ?

[sunny_talwar]

May be try this:

Sum({<NOM_PERIODE={$(=SELECTION)}>} VALEUR_METRIQUE)

[sunny_talwar]

Are you specifying 20160412-0025-24 chauffe (Without single quotes) or '20160412-0025-24 chauffe' (with single quotes) as your variable definition?

If it is without, may be you need this:

Sum({<NOM_PERIODE={$(=Chr(39) & SELECTION & Chr(39))}>} VALEUR_METRIQUE)

[swuehl]

Or

Sum({<NOM_PERIODE={'$(SELECTION)'}>} VALEUR_METRIQUE)

[#5]

It worked with

Sum({<PERIODE_NOM={'$(=vREFERENCE_NOM)'}>}METRIQUE_VALEUR)