TM1 web is different with Excel

林玫玫

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,