Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Specialist
Specialist

Formula with set expression

Hi experts

My KPI BU-1 is not working, there seems to be a resolving problem of YYYY-MMM. For BU-1 I get this information: 

TomBond77_2-1702048447387.png

For BU-2 the same:

TomBond77_3-1702048494756.png

 

KPI: BU-1

Sum({<[Timestamp.autoCalendar.YearMonth]=
{"$(= date(Max(Timestamp.autoCalendar.YearMonth), 'YYYY-MMM'))))"}>} Sales))

KPI: BU-2

Sum({<[Timestamp.autoCalendar.YearMonth]=
{"2023-Nov"}>} Sales))

TomBond77_1-1702048285908.png

Where is the error in Formula for KPI BU-1?

Thanks, tom

 

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Notice the quotes and braces are not in the correct positions in BU-1 as shown in the editor preview. 

-Rob

View solution in original post

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Notice the quotes and braces are not in the correct positions in BU-1 as shown in the editor preview. 

-Rob