Page 1 of 1

MMULT function in TM1

Posted: Wed Mar 04, 2015 3:48 pm
by elias912
Hi - has anyone got any code for doing the MMULT function within TM1 - thanks in advance !

Re: MMULT function in TM1

Posted: Wed Mar 04, 2015 8:39 pm
by declanr
MMULT is just doing simple multiplications and grouping them together; since TM1 doesn't have an equivalent formula you just have to break it down to the component parts and have a cell for each required calculation and then use the in built consolidations to get to the end result.

It's relatively straight forward in TI or Rules; you just need to ignore the concept of the MMULT formula and go back to the basics of multiplying arrays.