Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to have two conditions in one expression, exclude the quarters as well as one value within markets, though below expression returns an error. What is going wrong?
Max({$<[Period]-={'2020 Q3','2020 Q2','2020 Q1', '2020 Q4', '2019 Q3', '2019 Q2', '2019 Q1'} and {$<[Market]-={'ALL MARKETS'}>} [FirstTimeRight])
This one works
Max({$<[Period]-={'2020 Q3','2020 Q2','2020 Q1', '2020 Q4', '2019 Q3', '2019 Q2', '2019 Q1'}>} [FirstTimeRight])
Change it to:
Max({$<[Period]-={'2020 Q3','2020 Q2','2020 Q1', '2020 Q4', '2019 Q3', '2019 Q2', '2019 Q1'}, [Market]-={'ALL MARKETS'}>} [FirstTimeRight])
- Marcus
Not using -= which excludes the listed values else just = maybe so:
Max({$<[Period]-={'2020 Q3','2020 Q2','2020 Q1', '2020 Q4', '2019 Q3', '2019 Q2', '2019 Q1'}, [Market]={'North America'}>} [FirstTimeRight])
- Marcus
Change it to:
Max({$<[Period]-={'2020 Q3','2020 Q2','2020 Q1', '2020 Q4', '2019 Q3', '2019 Q2', '2019 Q1'}, [Market]-={'ALL MARKETS'}>} [FirstTimeRight])
- Marcus
Ah thanks I see here it doesn't work with an AND statement
@marcus_sommer what is the expression when you want to select only one item to the list, and not remove the item. E.g. I only want to have a table with North America selected
Not using -= which excludes the listed values else just = maybe so:
Max({$<[Period]-={'2020 Q3','2020 Q2','2020 Q1', '2020 Q4', '2019 Q3', '2019 Q2', '2019 Q1'}, [Market]={'North America'}>} [FirstTimeRight])
- Marcus
@marcus_sommer yes that works thanks. The solution is very straightforward I was working with a plus (+) sign instead of minus (-) which didn't work