Month to date

[razvan_brais]

Hy guys. What am I doing wrong in Month to date calculus? The result is 0 for this expression;

=Sum({<DATE={">=$(=Num(MonthStart(Max(GetFieldSelections(DATE)))))<=$(=Max(GetFieldSelections(DATE)))"}>} SALES)

[sunny_talwar · Accepted solution]

Do you select multiple dates or just a single date? May be try this:

=Sum({<DATE={">=$(=Date(MonthStart(Max(DATE)), 'DateFieldFormatHere'))<=$(=Date(Max(DATE), 'DateFieldFormatHere'))"}>} SALES)

[trdandamudi]

Can you share a sample with expected output..

In the above expression you are using "Num" for the greater than date, Is the date is numeric ?

[Anonymous]

may be helpful for you?

Set Analysis for certain Point in Time

[Anil_Babu_Samineni]

Would you be able to provide sample or try this too. I've added num function in the second date which you required

=Sum({<DATE={">=$(=Num(MonthStart(Max(GetFieldSelections(DATE)))))<=$(=num(Max(GetFieldSelections(DATE))))"}>} SALES)

[razvan_brais]

Thanks alot guys. It was the dateformat problem. I`m so happy when I see that I get answers so fast

Thank you again.