Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
What's wrong with this formula?
Sum(
{<[Timestamp.autoCalendar.YearMonth]=
{"$(= addmonths(date(Max(Timestamp.autoCalendar.YearMonth), 'YYYY-MMM')), -1)"}>}
Sales
)
This formula is fine:
Sum(
{<
[Timestamp.autoCalendar.YearMonth]=
{"$(= date(Max(Timestamp.autoCalendar.YearMonth), 'YYYY-MMM'))"}>}
Sales)
Thanks for your help, Tom
got it:
Sum(
{<
[Timestamp.autoCalendar.YearMonth]=
{"$(= date(addmonths(Max(Timestamp.autoCalendar.YearMonth), -1), 'YYYY-MMM'))"}>}
Sales
)
got it:
Sum(
{<
[Timestamp.autoCalendar.YearMonth]=
{"$(= date(addmonths(Max(Timestamp.autoCalendar.YearMonth), -1), 'YYYY-MMM'))"}>}
Sales
)