@ndivine: wow!
It's simple & it's understandable while reading --> nice!
Thanks to all contributers for the suggestions.
Best regards
Benoit
Search found 5 matches
- Tue Oct 09, 2018 12:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting the last date of a month in TI
- Replies: 10
- Views: 8209
- Fri Oct 05, 2018 10:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting the last date of a month in TI
- Replies: 10
- Views: 8209
Re: Getting the last date of a month in TI
Hello Wim and PavoGa, many thanks for your inspiring suggestion. Yes I use some Kind of serialisation. Here the workaround (all in TI, not in rules): intM2_brutto = intSourceMonth + intNumberOfMonthToShift; intM2_brutto = intM2_brutto + 1; intM2 = MOD ( 599 + intM2_brutto, 12) + 1 ; intY2 = intSourc...
- Thu Oct 04, 2018 2:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting the last date of a month in TI
- Replies: 10
- Views: 8209
Getting the last date of a month in TI
Hi, I'm used to get the last day of a month as the day before the first day of the next month: DATES ( myYear, myMonth + 1, 0) This works in Excel well but not in Tm1 TI Process! Month have to be there between 1 and 12 and days have to be between 1 and 28, 29, 30 or 31. Everything else lead to proce...
- Mon Nov 14, 2011 4:30 pm
- Forum: General
- Topic: Excel-wizard to migrate Excel-forms from Alea to Tm1?
- Replies: 4
- Views: 7422
Re: Excel-wizard to migrate Excel-forms from Alea to Tm1?
Hi Marcus and lotsaram, many thanks for your replies. The Reference update looks cute. I still didn't tested it, but the VB-Code makes a good impression. :D The biggest problem is that, even if Alea and Tm1 are near to each other, some differences make the Find/Replace to a torture: while Alea manag...
- Fri Nov 11, 2011 4:43 pm
- Forum: General
- Topic: Excel-wizard to migrate Excel-forms from Alea to Tm1?
- Replies: 4
- Views: 7422
Excel-wizard to migrate Excel-forms from Alea to Tm1?
Hi, we are migrating from Alea onto Tm1. Obviously we have a large amount of reports in excel where the functions have to be converted: DBGETC ->DBRW, DE.NAME -> SUBNM, and so on ... I am surely not the first one who have to cop with this. Does anyone know about Excel-assistent which can enlight the...