Skip to Content
0
Feb 19, 2009 at 08:45 PM

Measure calculates incorrectly when used as a percentage

128 Views

I have a measure in my universe called "loss ratio" with the following selectu2026

decode(PREMIUM, 0, 0, (value1/ PREMIUM))

Sometimes the "PREMIUM" field is zero, so I added the decode statement to resolve the "divide by zero error". The calculation is correct at the detail level, but when you start to aggregate the data it adds the results for each detail record instead of recalculating the formulae. If I turn off the "sum" feature for the measure, it only wants to show the data at the detail level.

I could add this measure in the report and it would works fine. My preference is to add this to the universe. Any way to do this?