-
-
13671698267 数据老手Lv5
发表于2020-12-4 12:06
悬赏1
已解决
楼主
if(if(dim(F_F_GRP02_XYWJZ.D_KPI,"D_KPI_CODE")='KPI0111',F_F_GRP02_XYWJZ.M_VALUE,0)=0|
if(dim(F_F_GRP02_XYWJZ.D_KPI,"D_KPI_CODE")='KPI0112',F_F_GRP02_XYWJZ.M_VALUE,0)=0,0,
if(dim(F_F_GRP02_XYWJZ.D_KPI,"D_KPI_CODE")='KPI0111',F_F_GRP02_XYWJZ.M_VALUE,0)/if(dim(F_F_GRP02_XYWJZ.D_KPI,"D_KPI_CODE")='KPI0112',F_F_GRP02_XYWJZ.M_VALUE,0))
我在表元中写了这样一段判断,但是出来数据全部是0,不知道什么原因,单独判断都是有数据的,if(dim(F_F_GRP02_XYWJZ.D_KPI,"D_KPI_CODE")='KPI0111',F_F_GRP02_XYWJZ.M_VALUE,0),
if(dim(F_F_GRP02_XYWJZ.D_KPI,"D_KPI_CODE")='KPI0112',F_F_GRP02_XYWJZ.M_VALUE,0)
if(dim(F_F_GRP02_XYWJZ.D_KPI,"D_KPI_CODE")='KPI0112',F_F_GRP02_XYWJZ.M_VALUE,0)=0,0,
if(dim(F_F_GRP02_XYWJZ.D_KPI,"D_KPI_CODE")='KPI0111',F_F_GRP02_XYWJZ.M_VALUE,0)/if(dim(F_F_GRP02_XYWJZ.D_KPI,"D_KPI_CODE")='KPI0112',F_F_GRP02_XYWJZ.M_VALUE,0))
我在表元中写了这样一段判断,但是出来数据全部是0,不知道什么原因,单独判断都是有数据的,if(dim(F_F_GRP02_XYWJZ.D_KPI,"D_KPI_CODE")='KPI0111',F_F_GRP02_XYWJZ.M_VALUE,0),
if(dim(F_F_GRP02_XYWJZ.D_KPI,"D_KPI_CODE")='KPI0112',F_F_GRP02_XYWJZ.M_VALUE,0)
最佳答案
13671698267 发表于 2020-12-4 13:32
在分析表的表元中这样写的
那换成case when这种 case when 条件1 then 结果1 when 条件2 then 结果2 else 结果3 end
6个回答
13671698267 发表于 2020-12-4 13:32
在分析表的表元中这样写的
那换成case when这种 case when 条件1 then 结果1 when 条件2 then 结果2 else 结果3 end
-
13671698267 数据老手Lv5
5#
xxxl 发表于 2020-12-4 14:01
那换成case when这种 case when 条件1 then 结果1 when 条件2 then 结果2 else 结果3 end
...
嗯嗯,表元中也可以写case when 是吧
-
13671698267 数据老手Lv5
6#
xxxl 发表于 2020-12-4 14:01
那换成case when这种 case when 条件1 then 结果1 when 条件2 then 结果2 else 结果3 end
...

这样写出的结果也是0,尴尬,不知道哪里出问题了