How to remove negative values

Questions & Answers
1

Hi,
I’m encountering an issue while using the following MDX to calculate the historical assignee for each issue. The calculation is returning negative values, which I want to exclude.

Is there a way to filter the results to only include positive values? It’s crucial to eliminate these negative values rather than simply hiding them. Otherwise, when performing summations, they will skew the results.

NonZero([Measures].[Transitions to assignee]-
[Measures].[Transitions from assignee])

image

2

Hi, @DamianoDB

To remove the -1 please consider adding CASE WHEN to your formula; read more here: CASE statement

The final formula might look something like this:

CASE WHEN ([Measures].[Transitions to assignee]-
[Measures].[Transitions from assignee]) >0
THEN
([Measures].[Transitions to assignee]-
[Measures].[Transitions from assignee])
END

Kindly,
Ilze