4 Replies Latest reply: Dec 11, 2012 2:08 AM by Perumal Ayyappan RSS

    how to calculation the sum value when the period is not one number but a time range

      I wanna calculate the sum value of the last year's period.

      but my selection of the period is not only a number, but a length of time.

      eg. my selection of period is from 201109 to 201202, :sum({$} value)

            so according to my definition of last year's period, the sum value should be sum the value from 201009 to 201102

      but I don't know how should the expression be. sum( {$<period= {$(=(period)-100)}>} value) is only supposed to be available when period selection is one number.