Skip to Content
0
Former Member
Jun 30, 2009 at 08:52 AM

Percentage and 0 in the universe

30 Views

Hi,

I have a problem with a field in the CR2008 and now need your help to create this field in the universe...

I calculate the % but the 0 is the problem in CR I have this

if  ( sum({SREPTimeAnalysis_query_1.Hours Standard}, {@Level Top}) - sum({SREPTimeAnalysis_query_1.Vacation Used}, {@Level Top})) <> 0
then (
sum({SREPTimeAnalysis_query_1.Hours Ext Billable}, {@Level Top}) / 
(sum({SREPTimeAnalysis_query_1.Hours Standard}, {@Level Top}) - sum({SREPTimeAnalysis_query_1.Vacation Used}, {@Level Top})) * 100
)

so I check for the 0 an then calculate... knows somebody a Oracle SQL solution for this problem with the 0?

thanks