Variable in Setanalysis.

[warrentk80]

Hello everyone, I need to use a variable in setanalysis.

the variable is called var_seriemax and must be set in series


I tried this string but the syntax is incorrect
= Sum ({$ <[number] = {} v_seriemax, AnnoSerie = {'2016'}>} [Budget €] / 1000000)

You would know someone show me how to do?

Thanks for collaboration

Andrew

[trdandamudi]

May be as below:

= Sum ({$ <[number] = {'$(v_seriemax)'}, AnnoSerie = {'2016'}>} [Budget €] / 1000000)

Note: Assuming your variable name is v_seriemax.

[swuehl · Accepted solution]

Not sure what you mean with 'must be set in series', try a dollar sign expansion in a set modifier like

= Sum ({$ <[number] = {'$(v_seriemax)'}, AnnoSerie = {'2016'}>} [Budget €] / 1000000)

[Anonymous]

= (Sum ({$ <[number] = {‘$(v_seriemax)’}, AnnoSerie = {'2016'}>} [Budget €]) / 1000000)

[Anil_Babu_Samineni]

Perhaps This, you made one mistake

Your variable is seems var_seriemax instead of v_seriemax

Can you please elaborate more what are you tried for variable of var_seriemax

= Sum ({$ <[number] = {'$(var_seriemax)'}, AnnoSerie = {'2016'}>} [Budget €] / 1000000)

OR

= Sum ({$ <[number] = {'=$(var_seriemax)'}, AnnoSerie = {'2016'}>} [Budget €] / 1000000)

OR

= Sum ({$ <[number] = {'$(=var_seriemax)'}, AnnoSerie = {'2016'}>} [Budget €] / 1000000)

[akshayjain90]

Use his -

= (Sum ({$ <[number] = {$(=$(v_seriemax))}, AnnoSerie = {'2016'}>} [Budget €]) / 1000000)

[ToniKautto]

Please keep in mind that the dollar expansion is done prior to the chart being calculated, so the expression can not dynamically change for row to to row in the chart results.

Set expression and dollar expansion