Thanks for the update. On Thu, May 5, 2016 at 2:57 PM, 耳东 <775620...@qq.com> wrote:
> The datatype is bigint. This problem is solved, when I change to double. > > > ------------------ 原始邮件 ------------------ > 发件人: "耳东";<775620...@qq.com>; > 发送时间: 2016年4月27日(星期三) 下午5:46 > 收件人: "dev"<dev@kylin.apache.org>; > > 主题: 回复: how to get the rate value > > > > the Kylin version is added in the description. > > > > > ------------------ 原始邮件 ------------------ > 发件人: "Li Yang";<liy...@apache.org>; > 发送时间: 2016年4月27日(星期三) 下午5:07 > 收件人: "dev"<dev@kylin.apache.org>; > > 主题: Re: how to get the rate value > > > > Please provide the Kylin version in the JIRA. > > On Wed, Apr 27, 2016 at 1:04 PM, ShaoFeng Shi <shaofeng...@apache.org> > wrote: > > > 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 > >