This discussion is archived
0 Replies Latest reply: Jan 24, 2013 3:32 AM by user471876 RSS

Conditional Formatting - to display text instead of Image

user471876 Newbie
Currently Being Moderated
Hi,

We have a requirement in a BI Finance Report wherein for an amount if it is NULL or 0 it needs to show '-' symbol.
Initially we placed a image in the Conditional Format Properties similar to that symbol, but it doesnt satisfy the requirement.
There are 35 metrics in 3 BI Reports each where we need to do this change. If we write a CASE statement, that will run for 30mins which will be a bad performance issue. So can we display a text instead of an Image using Conditional Formatting or any other way.

P.S. In one of the report, we have Union joins, so we cannot write a CASE statment for each metric in every report.

Please give your inputs.

Thanks in Advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points