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

[Clever_Anjos]

Please check your Date field format

[rustyfishbones]

try this

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

[#4]

thanks for your response but it is not working

[#5]

Thank you for your response

date field format is dd/mm/yyyy which i specified in the expression

[Clever_Anjos]

Is is possible post a sample of your data?

[rustyfishbones]

I am missing < (less than sign), sorry

try this

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

[#8]

thank you

is is giving me value but i wanted to see >= 9/01/2012 where can we give the greater than condition

[rustyfishbones · Accepted solution]

Here it is

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

[rustyfishbones]

please mark if correct