Worksheet Filter AND / OR logic

Worksheet Filter AND / OR logic

During an analysis, a user may want to show for a specific deviation (for example Actual vs Budget) all items that have a deviation of -1000 OR +1000. 

Next time he uses the same worksheet, this may be a different boundary or even a different line item (for example Actual vs LY). In classic UX, this was simply possible via the filter function ALL / ANY (see picture 1).

The NUX worksheet allows currently only AND logic, OR is not possible (see picture 2).

 

Current workaround is to follow best practises and create a boolean formatted line item hosting the filter logic.

However, this approach has limitations or would require a complex technical solution when the filter is (1) user based and (2) the criteria is largely variable.

In such use cases, the built-in worksheet filters offer an easy and very helpful solution.

 

PhilippErkinger_1-1603808890058.pngPhilippErkinger_0-1603808801751.png

Users Online
Currently online: 74 members 436 guests
Please welcome our newest community members: