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: |
Tagged:
0