Hi all:

      I want to get a value which is defined as sum(a)/sum(b), how can I do 
this kind of anlysis.
     
      Now I build a cube which have sum(a) and sum(b), when I execute ??select 
sum(a)/sum(b) from table1 group by c?? ,the result is wrong. sum(a)/sum(b) the 
result is all 0 and sum(b)/sum(a) result is all 1.


         MMENE_NAME    SUCC   ATT    SUCC/ATT  
     CSMME15BZX   336981   368366   1  
     CSMME32BZX   338754   366842   1  
     CSMME07BZX   687965   747694   1  
     CSMME03BHW   703269   747623   1  
     CSMME12BZX   705856   764656   1  
     CSMME16BHW   1962293    142173   1  


       MMENE_NAME   SUCC   ATT   ATT/SUCC  
     CSMME15BZX   336981   368366   0  
     CSMME32BZX   338754   366842   0  
     CSMME07BZX   687965   747694   0  
     CSMME03BHW   703269   747623   0  
     CSMME12BZX   705856   764656   0  
     CSMME16BHW   1962293    142173   0

Reply via email to