6 Replies Latest reply: Sep 13, 2016 5:10 AM by akshay jain

Variable in Setanalysis.

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

• Re: Variable in Setanalysis.

May be as below:

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

Note: Assuming your variable name is v_seriemax.

• Re: Variable in Setanalysis.

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)

• Re: Variable in Setanalysis.

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

• Re: Variable in Setanalysis.

Perhaps This, you made one mistake

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)

• Re: Variable in Setanalysis.

Use his -

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

• Re: Variable in Setanalysis.

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