Active from row format not carried over to TM1web

Post Reply
bjones
Posts: 24
Joined: Tue Apr 08, 2014 4:17 pm
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 2010

Active from row format not carried over to TM1web

Post by bjones »

I have an active form with rows that have dollars and other that have percentage. In order to get this i added a new row in the formatting region on top and applied the formatting to the rest of the active form. Everything works fine in Perspectives after rebuilding the sheet.
Once i upload it to tm1 and open in tm1web everything is in dollars.

Did anyone see this before?
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Active from row format not carried over to TM1web

Post by declanr »

What did you change the row formula to in order to get the extra format letter/number?
Seen issues before when changing that formula in certain ways (e.g. people trying to use a dbrw instead)
Declan Rodger
bjones
Posts: 24
Joined: Tue Apr 08, 2014 4:17 pm
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 2010

Re: Active from row format not carried over to TM1web

Post by bjones »

This is what i added at the end of the formula IF(ISNUMBER(FIND("%",B34)),"P", "N"))
P is the row configured for percentage
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Active from row format not carried over to TM1web

Post by declanr »

http://www-01.ibm.com/support/knowledge ... ons_NF0579

Isnumber doesn't seem to be supported.
Declan Rodger
bjones
Posts: 24
Joined: Tue Apr 08, 2014 4:17 pm
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 2010

Re: Active from row format not carried over to TM1web

Post by bjones »

Makes sense :)
Thanks for your help
Post Reply