Title says it all, a XOR formula would be really helpful and reduce formula length when trying to test an exclusive or.
For those unfamiliar, here is the logic table for XOR. It acts as an OR however if both inputs are TRUE, then XOR returns false.
@Nicolas Cadier
One use case I can think of that might take advantage of this is when I need to make sure I have one, and only one, TRUE. I do this all the time for validation work. Would you envision this working across a list? Meaning it tests all the list items and only returns a TRUE if only one of the conditions is TRUE?
Note XOR gate definition produces a 1 logic output for an input of an ODD number of logic 1s, hence it will be Exclusive for two arguments only.
If you'd like an Exclusive function or operator over a list of arguments, (only one TRUE argument produces a TRUE output) then you may use 1=(the count or sum of the 1s).
Background: The first click of a context selector on a NUX board the entire hierarchy opens out all levels right down to the lowest level. This means the user (all users, but focused on business/end users, executive-level) has to manually collapse each level they are not interested in seeing to navigate to the area they…
Problem Statement: There is a business need to allow users to filter and analyze data based on specific times (e.g., 14:30). The current 'Date' format in Anaplan does not provide this level of granularity. This functionality is essential for time-sensitive planning and analysis use cases where differentiating between…
The core idea is to have UX Cards automatically update when the Card UX has changed: new line items into a grid or Field Card, conditional formatting rules change, etc when the same card is displayed multiple times. Example: User Filter Cards I have the same User Filter card on 90% of my Pages - let's call it 16 Pages. I…