Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ignore selection with set expressions

Hi all,

I'm trying to ignore selections in the field [Booking Month] and at the same time forcing to get the higher value for the field [Booking Week] with this formula and it's not working:


sum({<[Booking Month],[Booking Week]={"$(=date(max([Booking Week])))"} >}Pax)


If I use the next formula I ignore the selection made in [Booking Month] field:


sum({<[Booking Month]} >}Pax)


and if I use the next formula I will get the result for the higher value for [Booking Week] field:


sum({<[Booking Week]={"$(=date(max([Booking Week])))"} >}Pax)

Do you know how can I combine both? maybe is because both dimensions are related?


thanks,


David

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Are you looking for clearing user selections also in the max() aggregation?

sum({<[Booking Month],[Booking Week]={"$(=date(max({<[Booking Month]>} [Booking Week])))"} >}Pax)

View solution in original post

4 Replies
trdandamudi
Master II
Master II

May be as below:


sum({<[Booking Month]=,[Booking Week]={"$(=date(max([Booking Week])))"} >}Pax)

Not applicable
Author

Thanks but it doesn't work eihter

swuehl
MVP
MVP

Are you looking for clearing user selections also in the max() aggregation?

sum({<[Booking Month],[Booking Week]={"$(=date(max({<[Booking Month]>} [Booking Week])))"} >}Pax)

Not applicable
Author

That's the solution,

Thanks a lot Swuehl!!