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)