EPM Formatting in Report

[Former Member]

Hi,

I am facing challenge in applying conditional formatting on the column in one of my report.

	Quantity (A)	Price (B)	Warning (C)
Account1			if either of quantity or price is zero, warning becomes red
Account2	10		Red
Account3		2.5	Red
Account4	10	3	Green

Any suggestion, that can help me to achieve this through EPM formatting. based on some online documents on conditional formatting, I tried to do that but not able to solve it. what I tried is. I entered a local member next to warning column and put the flag such as

	Quantity (A)	Price (B)	Warning (C)	Flag (local Member formula) (D)
Account1				if either of quantity or price is zero, Flag becomes "False" else "True"
Account2	10		Red (if Flag is False)
Account3		2.5	red (if flag is false)
Account4	10	3	green (if flag is true)

Based on screenshot attached, I went to EPM formatting sheet and then Dimension Member Property formatting, Selected "Warning" from dimension and then under data region, I applied conditional formatting like $K14="False", then formatting becomes red. but it doesn't apply, instead it automatically goes to $K65443="False".

Please suggest

Regards,

[former_member186338 · Accepted solution]

You have to use references in conditional formatting related to cell in the formatting sheet.

$K - fixed column in the report.

Instead of 14 use row number of the cell on the formatting sheet!

Vadim

[Former Member · Accepted solution]

Thanks Vadim, missed to attach screenshot. I think 14 is the row number. when I define conditional

formatting in EPMformatting sheet, click on new rule, I define like $K="X", it doesn't take, if define like K:K="X", this doesn't work either, if I define like $K14="X", it automatically goes to $K65443=X.

Regards,

[former_member186338 · Accepted solution]

In the EPM formatting sheet, when you define condition for conditional formatting you have to use row number of the cell on the formatting sheet - NOT row of the report sheet!

Will be something like:

$K60="X"

Where 60 - is the row number on the formatting sheet!

Show formatting sheet screenshot!

Vadim

[former_member186338 · Accepted solution]

Like:

[Former Member · Accepted solution]

Thanks a lot vadim, it worked, I didnt know that I had to select row from formatting sheet and was trying in report sheet.

Regards,