can any one help me set analysis

[#1]

sum({$<Date={">=09/01/2012"},Item={'PAN 34g'}>} Units)

i am using this one but not getting any result it is showing me zero value

but when i take out date and sum it for total for ex

=sum({<Item ={'PAN 34g'}>} Units)

thanks in advance

[stevedark]

Hi there,

This will almost certainly be a problem with the data format.  First up, can you check the format your date is presently in.  If you add a list box you should see the natural format, also the sort order should show you if it the date is stored as a numeric or as text.

If the date is stored as text then you will need to convert it to a true date field on the way into the document, using a Date# function.

You can force the format of the date field in the load using a Date function, this way you know what format it is you need to match to in Set Analysis.

The format of the date value in the set analysis expression must exactly match that of the natural format of the date in your data model.

If you can upload an example document then I can take a look at it for you.

Regards,

Steve

[stevedark]

Sorry to be pedantic - but does the expression Alan has given not require an equals sign to include values that fall on 09/01/2012?

SUM({$<Date ={">=$(=Date('09/01/2012'))"},Item={'PAN 34g'}>} Units)

-Steve

[rustyfishbones]

Ha! pedantic Steve, you are probably correct.

I'd trust you before I would trust me

hope the Masters Summit went well