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).
Need a way to periodically export all revision tags within an Anaplan model into a excel file to simplify audit and documentation process, but Anaplan currently has no native option to do this. The existing workarounds are all imperfect: the revision tags page can't be copied directly (the "Compare" pop-up only captures…
Has anyone seen this before? (1) Click a cell in an Anaplan Grid (2) Check something in Excel (3) Go back to the Anaplan page (4) Press the arrow keys After step (4), the arrow keys no longer move between cells. Instead, the Grid/page scrolls. The only way to get cell navigation back is to click a cell in the Grid again…
When you create a slicer, the displayed characteristic defaults to Caption with no way to change it. Our user community is accustomed to using Name for slicers so this has been a tough adjustment. As for now, we've been connecting an XL3 formula to the slicer output to give us the relevant information and just changing…
