Variable use in September analysis.

[warrentk80]

Goodmorning everyone

I need to use in the comparison of a setanalisys a formula, a variable rather than a fixed value.

I'll explain :
currently I use the formula that is:

num = (sum ({1 <[Flg Activity Type] = {'F'}, [Series] = {'20150930'}>} [Budget in €] / 1000000), '### 0,0')

I, however, more serious so instead set the value 20150930 I would insert a variable seriemax that I set as MAX (Series)
I tried using the syntax
num = (sum ({1 <[Flg Activity Type] = {'F'}, [Series] = {} = SerieMax>} [Budget in €] / 1000000), '### 0,0')
but the formula returns error.

can you help me?

Thank you

Andrea

[swuehl · Accepted solution]

Maybe

(sum ({1 <[Flg Activity Type] = {'F'}, [Series] = {'$(=Maxstring([Series]))'} >} [Budget in €] / 1000000), '### 0,0')

or if you already have a correctly formatted variable

(sum ({1 <[Flg Activity Type] = {'F'}, [Series] = {'$(SerieMax)'} >} [Budget in €] / 1000000), '### 0,0')