
Specialist
2023-12-11
05:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set expression with Addmonths
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
Labels (6)
Labels
- Subscribe by Topic:
-
Client Managed
-
Developers
-
expression
-
General Question
-
Set Analysis
-
Variables
1 Solution
Accepted Solutions

Specialist
2023-12-11
05:41 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
got it:
Sum(
{<
[Timestamp.autoCalendar.YearMonth]=
{"$(= date(addmonths(Max(Timestamp.autoCalendar.YearMonth), -1), 'YYYY-MMM'))"}>}
Sales
)
1 Reply

Specialist
2023-12-11
05:41 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
got it:
Sum(
{<
[Timestamp.autoCalendar.YearMonth]=
{"$(= date(addmonths(Max(Timestamp.autoCalendar.YearMonth), -1), 'YYYY-MMM'))"}>}
Sales
)
