All eazyBI for Jira eazyBI for Confluence Private eazyBI

Abs

The Abs function in MDX returns the absolute value of a numeric expression. Converts any negative number to its positive counterpart, while positive numbers remain unchanged.

Syntax

Abs(Numeric_Expression)

Arguments

Numeric_Expression

MDX expression that returns a numeric value

Examples

Determine the variance in Store Sales

The following MDX expression calculates the variance of Store Sales between two consecutive time periods. The variance is determined by finding the difference between the sales values of the current period and previous periods' sales values.

Abs([Measures].[Store Sales] - ([Measures].[Store Sales], [Time].CurrentMember.PrevMember))

Resolution deviation from the Due date

The following MDX expression calculates the absolute difference between the Due Date and the Resolution Date of an issue to understand how much the resolution has deviated from the due date.

ABS(DateDiffDays([Measures].[Issue resolution date], [Measures].[Issue due date]))

See also