BICS - Expression Does Not Format Percentage Correctly In Answers
Last updated on JUNE 21, 2016
Applies to:Oracle Business Intelligence Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On Business Intelligence Cloud Services (BICS), the below scenario is noticed:
- Answers are not showing correct percentage result when creating an expression using the same field twice.
- To get the right result, you are including *100 to the expression
- A / (A+B) = C (where C is a percentage. This is the result that does not display correctly in Answers ).
- On including *100 as below, the result D will show correctly as a percentage on a Dashboard.
- (A (A+B))*100 = D
Note-D is now a percentage number.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms