Insight (OBIEE) Tips | How to fix a Calculated Percentage Column only showing 0.00%

So you’ve done the hard part and created a custom metric to show a rate (a calculated percentage) but you hit results and see all zeros (0.00%).

Not to worry there is a simple solution to fix your formula, we just need to tweak the syntax.

When an integer is used in a calculation you will need to multiply the calculation by 1.0 (ensure you use 1.0 not 1, as 1 will not work).

Here’s an example of what your formula should look like:

(1.0*("Activities"."Unique Clickthroughs" - "Activities"."Total Unsubscribes by Email"))/ (1.0*("Activities"."Total Delivered"))*100

Hope this little tidbit helps!

Otilia