Set Analysis syntax

[hobanwashburne]

Bear with me, I'm new to this.

I have the following expression which seems to work for the sum of net sales during fiscal period 201212

=sum({<FiscalPeriod = {"201212"} >}NetSales)

However, the following expression does not work for the sum of net sales between fiscal periods 201212 thru 201302

=sum({<FiscalPeriod = {">=201212 <=201302"} >}NetSales)

What am I missing?

//----------------------------------------------------------------------------------------------------------------

For some reason I can’t reply on
this post… anyway

Sorry to say guys, none of the
suggestions have worked. (BTW Steve, I believe you left out a single quote in
your expression.) I would rather not post the actual file due to size and the
fact that it is our company's financial data. However, I would really like to
know what is going on.

As far as a possible bug goes, I'm
running v10.00.8715.5 IR 64-bit Edition (x64)

I have the dates formatted in the
table load as follows:

Date#(SLGLPR,'YYYYMM') as FiscalPeriod,

and the initial load as

DateFormat='YYYYMMDD';

I changed the initial load to the
following, but it had no effect

DateFormat='YYYYMM';

[#2]

Try single quotes =sum({<FiscalPeriod = {'>=201212 <=201302'} >}NetSales).

That should work

[sathishkumar_go]

Hi, Could you please attache the application here? Regards Sathish

[#4]

Single quotes should do it.

However, I believe I encountered a bug with a similar model of mine, where I could not get the syntax to work out (and I spent days and involved an external consultant who couldn't figure out the issue).  So my rather ugly get out was the below formula (only use this as a last resort as I'm sure the performance is far from optimal).

=sum({<FiscalPeriod = {'>=201212'} * FiscalPeriod = {<=201302'} >}NetSales)

The * requests the intersect of the two conditions, i.e. everything between the two dates in this case.

I hope that helps.  Let me know how you get on.

Steve

[pgrenier]

Good day,

I believe the proper expression would be the following:

=Sum({<FiscalPeriod = {">=201212"} * {"<=201302"} >} NetSales)

Regards,

Philippe

[#6]

Good spot Phillippe!! 

[v_iyyappan]

Hi,

Do u check the FiscalPeriod Dateformat like "201212". If it is not means please change the Dateformat FiscalPeriod as 'YYYYMM'.

And use the expression like

=Sum({<FiscalPeriod={'>=201212 <=201302'}>}NetSales)

Regards,