Edit Formula and use Case When Statement will enable you to change the sign based on Account Range
1 person found this helpful
You can create a new column Y in the BMM layer based on the incoming field X.
The formula to change the sign would be 0 - X, you can then expose this column in the presentation layer.
If you always want a +ve value then you can use ABS(X)
Mark Answered if this has helped
Building on your answer - on the income statement data column we have revenue and expense amounts - how would we only have the *rows* with revenue data displaying the data as positive number?
Can this BMM layer manipulation work on rows as well?
Do what 3055888 said: a CASE WHEN <account columns> = 'Revenue' THEN <your fact> * -1 ELSE <your fact> END
Of course all the options posted works: 0 - x, x * -1, ABS(x)
You are supposed to have a dimension or an attribute somewhere allowing you to identify your revenues to use as condition in the CASE WHEN.
You can also use ABS and 0 - measure in the column formula
Sent from my iPhone