TM1 web is different with Excel
Posted: Sun Sep 08, 2013 10:16 am
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,
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,