2 Replies Latest reply: Jul 22, 2018 9:12 AM by Petter Skjolden RSS

    hmmmm....

    Kenneth Holden

      (sum({1<[FIS YEAR]={'2017'}>} UNITS))-(sum(UNITS))

       

      This should give me all of 2017 units, ignoring dimension selection, minus 2018 units.......but it does not, in fact, it does not subtract at all.

       

      just get 2017 total units. zits as if it completely ignores the subtraction.

       

      what am I doing wrong?

       

      Thank you.