Max Date Month

[mariamovasheli]

Hi,

I Want to sum MAX MONTH DATE with date field. I use This formula

sum({<Month={'$(=Month(max(Date)))'}>}Volume) and It does not work can you please Tell me What to do?

[MK_QSL]

SUM({<Month = {"$(=Month(Max(Date)))"}>}Volume)

or

SUM({<Month = {"$(=Month(Max({1}Date)))"}>}Volume)

or

SUM({<Date = {">=$(=MonthStart(Max(Date)))<=$(=MonthEnd(Max(Date)))"}>}Volume)

or

SUM({<Date = {">=$(=MonthStart(Max({1}Date)))<=$(=MonthEnd({1}Max(Date)))"}>}Volume)

I am assuming that Month field is having same format as the MonthNames variable's month format.

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';