hi dong, could you please open a JIRA to Kylin for tracking this issue? https://issues.apache.org/jira/secure/Dashboard.jspa
Thanks! 2016-04-26 20:56 GMT+08:00 耳东 <775620...@qq.com>: > 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 -- Best regards, Shaofeng Shi