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