Set Analysis for not equal to Day Month

[amars]

Hi all,

I wish to check if a Date <> '1 Jan' using Set Analysis. Here the Year can be anything but just need to check if the Day and Month should not be 1 Jan.

Thanks in Advance.

Amar

[#2]

HI,

Try this

=sum({<Date=-{'Jan 1'}>}Data)

Please find the attachment

[senpradip007]

Try this

=Sum({<Date = {'*'} - {'01/01/*'} >} Sales)

[phaneendra_kunc]

Assuming you have a date field with format like 1/1/2014, if so i would suggest to add another field to your calendar to compute "DAY MONTH" may be using this Date(YOUR DATE FIELD,'DMMM') as Day_Month and you can use this in your expressions to filter out..

sum({<Day_Month-={'1Jan'}>} YOUR FIELD)

Note there is a MINUS "-" infornt of the equal sign, this means "Not Equal to"

Hope this helps..

[amars]

Thanks Phaneendra,

My issue I need to check 10 different date fields in one Expression. I can not afford to create 10 new Fields just for one report. I need to check inside my expression only. I have D MMM YYYY format in which I need to check dates where they do Not start on 1 Jan.

I Tried something like [DATE Field] -= {"= Date([DATE Field],'D MMM')  =  '1 Jan'"} but is not working as expected.

Please anyone have any other suggestion.

Thanks...

[phaneendra_kunc]

Perhaps may be like in attached.

[#7]

Hi,

Just create month_day (For eg:  num(month(Date_fiels)) &'-'& day(Date_Field) as month_day) field in script and use that in set analysis.

=sum({<month_day=-{'1-1'}>}Data)