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?