SAP DATA WAREHOUSE CLOUD COMMUNITY

This is your platform to ask questions, post answers and share your experience with other customers and experts from SAP.

Measure/dimension with only positive or negative values

I´d like to see all of the positive values in one dimension together compared to all of the negative values. Like you have a currency dimension and you´d like to see all positive values in USD and all negative values and so on for other currencies

What is the easiest way to do this? I am apparaently to stupid to achieve this.

I tried restricted measures but failed since there is no conditon on pos. or neg. values

I tried agreggated measure but there again is no conditon on pos. or neg. values

I tried to key in a if-formula in the calc. editor. This does not work either since it than shows me the net pos. or neg. value or 0 (IF(["Model":Value]<0 ;["Model":Value] ;0 )


Any ideas?

Answers

Sign In or Register to comment.