In TM1 Rules, I'm subtracting two dates to get the remaining months to forecast, first converting the date into DAYNO then converting into months. In this case say for eg in excel. Today 21/08/2013 >> 41507 & Completion Date 1/10/2013 >> 41548

x = (41548 - 41507) = 41 days = 12*(41/365) = 1.347

If in excel I can use ROUNDUP(1.347) to get 2, but in TM1 has ROUND & ROUNDP which was not doing a favour.

I got some more information about ROUND function in this http://pic.dhe.ibm.com/infocenter/ctm1/ ... round.html, but nothing works. Anybody has come across this situation, please help.

Code: Select all

`ROUND(12*(((DAYNO(ATTRS('Site', !Site, 'Completion Date'))) - (DAYNO(TimSt (NOW,'\Y-\m-\d'))))/365 )),2,0)`