You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

percentage format in Reports

Summary:

Column A = retrieved from dimension

Column B = retrieved from dimension

Column C (Formula) = IfThen (DIFFERENCE([A],[B]) = 0, 0, DIFFERENCE([A],[B]))

We have a requirement to show formula type of column C to show percentage in below format:

If Column C is positive, show in red color as 0.2%

If Column C is negative, show in normal black color as (0.2%)

I applied cell properties, but it does apply the suffix and prefix for negative values.

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):

Version

Service:

Enterprise Performance Management Enterprise Cloud

Business Process:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!