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