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

# 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.

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

Hi,

Try this expression

sum( {\$<period= {'>=\$(=Date(2010/09/01))<=\$(=Date(2011/02/01))'}>}Value)

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

Why dont you post a sample?

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

sum( {\$<period= {'>=\$(=Date(2010/09/01))<=\$(=Date(2011/02/01))'}>}Value) is a great way

but my period will be changed with my period selection

I revised a little--> sum( {\$<period= {'>=\$(=min(period)-100)<=\$(=max(period)-100)'}>}Value)

but it didn't show the right data.

ps. the format of period is not a Date.

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

Hi,

Please post sample application for my reference

Regards

Perumal A