Search found 3 matches

by nicesloper
Wed May 20, 2009 12:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rounding in TM1
Replies: 8
Views: 9927

Re: Rounding in TM1

Thanks a lot for the quick help you all. I tried and it worked, using elements and not numbers. But is it possible, just to get a rounded result in the same row or column of a table (eg. row "cost" with three columns: 1,1234 / 3,7891 / 5,6549 then doing the rounding and in the same row &qu...
by nicesloper
Tue May 19, 2009 4:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rounding in TM1
Replies: 8
Views: 9927

Re: Rounding in TM1

it's not awful, but I didn't and don't see a possibility in solving my problem. If I want to create a rule with round/roundp - the tm1 handbook tells me to insert a number "round(1,46,1)" in the rules editor. This works fine. But isn't it possible like in Excel to use a function like ROUND...
by nicesloper
Tue May 19, 2009 3:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rounding in TM1
Replies: 8
Views: 9927

Rounding in TM1

Hi all, is there any possibility to create a rule for doing rounding without the usage of following functions ROUND and ROUNDP? Or is it possible to do coding to solve this problem? The problem I am faced is, to do roundings for elements like costs and revenues. There are only two digits allowed aft...