Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
May be as below:
= Sum ({$ <[number] = {'$(v_seriemax)'}, AnnoSerie = {'2016'}>} [Budget €] / 1000000)
Note: Assuming your variable name is v_seriemax.
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)
= (Sum ({$ <[number] = {‘$(v_seriemax)’}, AnnoSerie = {'2016'}>} [Budget €]) / 1000000)
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)
Use his -
= (Sum ({$ <[number] = {$(=$(v_seriemax))}, AnnoSerie = {'2016'}>} [Budget €]) / 1000000)
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.