Page 1 of 1
Active from row format not carried over to TM1web
Posted: Mon Jan 12, 2015 6:46 pm
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?
Re: Active from row format not carried over to TM1web
Posted: Mon Jan 12, 2015 6:56 pm
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)
Re: Active from row format not carried over to TM1web
Posted: Mon Jan 12, 2015 7:19 pm
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
Re: Active from row format not carried over to TM1web
Posted: Mon Jan 12, 2015 7:23 pm
by declanr
Re: Active from row format not carried over to TM1web
Posted: Mon Jan 12, 2015 7:27 pm
by bjones
Makes sense
Thanks for your help