1 Reply Latest reply: Oct 29, 2015 3:41 AM by Stefan Wühl

# Variable use in September analysis.

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

• ###### Re: Variable use in September analysis.

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')