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