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

Reply via email to