Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
Name | Month | Year | Message |
Max | 1 | 2022 | Yes |
Max | 2 | 2022 | Maybe |
Max | 3 | 2022 | Maybe |
Max | 4 | 2022 | No |
Max | 5 | 2022 | Yes |
Im looking for a way to create a set analysis, but the result isnt a value but a text.
It should be like if Month=5 and year=2022, then 'Yes' else blank.
Would you use a set-analysis for it with 'only' function?
IF you trying to create a calculated Message field, then use
=IF(Month=5 and Year=2022,'Yes')
OR
IF you are trying to retrieve the text value from the Message field that exists in your data , then use
only({<Month={'5'},Year={'2022'}>} Message)
or MaxString({<Month={'5'},Year={'2022'}>} Message)
IF you trying to create a calculated Message field, then use
=IF(Month=5 and Year=2022,'Yes')
OR
IF you are trying to retrieve the text value from the Message field that exists in your data , then use
only({<Month={'5'},Year={'2022'}>} Message)
or MaxString({<Month={'5'},Year={'2022'}>} Message)