0 Replies Latest reply: Jan 24, 2013 5:32 AM by user471876 RSS

    Conditional Formatting - to display text instead of Image

    user471876
      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