Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Condition not working on Measure column
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.
Answers
-
Hi,
Use the case statement in the Measure formula for this requirement.
eg.
case when 'measure' >100 then 'Do Not Consider' else
'measure' end
Thank You.
0 -
THis is throwing error saying incompatable data types. Please suggest me work around in answers? Not in rpd
0 -
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]
0 -
Use conditional formatting
0