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

    Variable use in September analysis.

    Andrea Masciulli

      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