> and <= doen't work

[#1]

hi~ im lee from s.Korea.

i have one question.

i want to have result........ to 2014-10-14   from 2014-10-02  data.

so i use ... (example)    {{{    ='<=$(=date($(v_SearchDateEnd)))'     }}}

$(v_SearchDateEnd) is 2014-10-14

$(v_SearchDateStart) is 2014-10-01

and .. {{{    ='>$(=date($(v_SearchDateStart)))'    }}}

but the result...  2014-10-01  ~~~ 2014-10-13.

why doesn't work > and <=....

please help me..

[jagan]

Hi Lee,

Try this expression

Sum({<DateDimensionName= {'>$(=Date(v_SearchDateStart))<=$(=date(v_SearchDateEnd))'}>} MeasureName)

Make sure that DateDimensionName, Date(v_SearchDateStart) and Date(v_SearchDateEnd) are in same format YYYY-MM-DD.

Hope this helps you.

Regards,

Jagan.

[#3]

What is MeasureName?

[jagan]

Hi,

Replace MeasureName with your numeric fields like Sales or Quantity or Revenue etc.

Regards,

Jagan.

[villegasi03]

its the field that you are aggregating

[#6]

=Sum({<SUM_DATE= {'>$(=Date(v_SearchDateStart))<=$(=date(v_SearchDateEnd))'}>} SUM_DATE)

....it's not working.....

[jagan]

Hi Lee,

Do you need the sum of all dates (SUM_DATE)?  Can you attach the sample file, I am not sure what you are trying to do.

Regards,

jagan.

[villegasi03]

I am still not understanding what you are SUMMING. The previous person trying to help said to replace his field called 'MeasureName' with 'your field'. You reply with a alternate expression with the field that you are aggregating called 'SUM_DATE'. I have a feeling you are leaving something out based on the name of your field.........

What are you summing??????????

[#9]

sorry, i'm not good at english...

anyway.. i solved it

thank you guys~

[jagan]

Hi,

If you got the answer close this thread by giving correct and helpful answers to the useful posts.

Regards,

Jagan.