Introduced this new function in I2024.2.0 to provide full server-side control over tuple evaluation that is completely decoupled from the query's grouping or filter context.
NULLEXCEPT( ) - evaluates the given tuple expression when the query includes any of the hierarchies listed in the hierarchies set argument, else NULL is returned. Totals that the hierarchy set contribute to are displayed, else a NULL value is displayed for the Total (applies to subtotals and grand total). Great for associating an expression with a narrow set of hierarchies, allowing the Data Model Architect to control the display of information without having exact control over how the expression will be used by report users. Overcomes the limitation of the tuple syntax which requires a coordinate reference in the form of a member expression.