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?
Active from row format not carried over to TM1web
-
- 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
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)
Seen issues before when changing that formula in certain ways (e.g. people trying to use a dbrw instead)
Declan Rodger
-
- 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
This is what i added at the end of the formula IF(ISNUMBER(FIND("%",B34)),"P", "N"))
P is the row configured for percentage
P is the row configured for percentage
-
- 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
Declan Rodger
-
- 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
Makes sense 
Thanks for your help

Thanks for your help