Condition not working on Measure column

Question

i have a measure column.on that column i want to display 'Do not consider' text instead of value if the absolute value is greater than 100. Because of differences in data types its throwing error. anyone suggest how can i display Text 'Do Not Consider' if the absolute value of measure column is greater than 100.

plyskovich · Answer

Use conditional formatting

choracy69 · Answer

Hi,

This formula is a bit of a misnomer, because if you use CASE WHEN for measure column, it must be the same type of output, and IN THIS case is 'Do Not Consider' and measure column.

You can use something like that:

CASE WHEN "Fact"."MeasureColumn" > 100 THEN 'Do Not Consider' ELSE 'OK' END

You can't use:

CASE WHEN "Fact"."MeasureColumn" > 100 THEN 'Do Not Consider' ELSE "Fact"."MeasureColumn" END

But If you want use this formule, you can use CAST function, for example: CAST("Fact"."MeasureColumn" AS VARCHAR(10))

More information: OBIEE - Case When Statement [Gerardnico]

user12863665 · Answer

THis is throwing error saying incompatable data types. Please suggest me work around in answers? Not in rpd