Den absolutte værdi

Her er et eksempel på hvordan man beregner den absolutte værdi af et givent Measure.

Code Block

WITH
 MEMBER [Measures].[Neg Profit] AS ‘-1 * [Measures].[Profit]’
 MEMBER [Measures].[Abs Profit] AS ‘ABS([Measures].[Neg Profit])’
SELECT
 {[Measures].[Neg Profit], [Measures].[Abs Profit]} ON COLUMNS,
 NON EMPTY DESCENDANTS( [Customers] ) ON ROWS
FROM
[Sales]

 

Loading

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.