企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 235|回复: 0

TM1 web is different with Excel

[复制链接]

78

主题

403

帖子

578

积分

高级会员

Rank: 4

积分
578
QQ
发表于 2014-3-18 21:45:10 | 显示全部楼层 |阅读模式
Hi,

I have create some customize report in TM1.
when view in Excel, there is no problem.
but when upload into the web. the column run, format not the same.

The major differences are the excel formula become incorrect.
C8 =DBRW($A$1,$A8,$C$4,$J$1,C$5,C$6,$L$1)
D8 =DBRW($A$1,$A8,$C$4,$J$1,D$5,D$6,$L$1)
E8 =IF(OR(C8="",D8=""),"",C8-D8)
G8 =IF(OR(E8="",E8=0),D8/E8,F8)

however, it will show #Value! although I already put if statement to make it become 0/ blank
M8=DBRW($A$1,$A8,$M$4,$J$1,M$5,C$6,$L$1)
N8=IF(OR(M8="",C8=""),"",M8/C8*100)

the weirdest part is the cell show 0/ blank in excel for N8.
but when upload into web, the figure become 100.

I have no idea why have this big differences?
have any way to work out with this?

Thanks,
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2020-7-2 17:46 , Processed in 0.209502 second(s), 13 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表