Fusion Analytics Warehouse
OTBI values show as %
kindly find the below:
I have created a report analytic
i have a column that show me the difference between 2 formulas
how can i modify it so i can see the value in %
as i know I can put /100 but I want the % to appear
We need to change the column properties and override the data format as %. Refer the screenshot :
In addition, the last option : 'Scale for % (x 100)' is newly added in 12C. It might help too to get the percentage.
Thank you so much it worked
Thanks for the details @Laxman Pondey-Oracle !
Appreciate your help.