Page 2 of 2

Re: Problem with calculation

Posted: Fri Mar 11, 2016 1:28 pm
by marac2203
I'm sorry if you have to shout but I'm new in TM1 with zero experience. If anyone can help with these: I have to createprocess not rule that woul calculate fakturiranost/nefakturiranost according to data from cube Radni sati and cube Uloga na projektu. Example: For Dražen Horvat it would be 10*5=50 SO fakturirano would be 50 EUR.

I didn't manage to get HRK from last posts so it would be enough for EUR.

Sorry, one more, but I'm new in whole story. Maybe it seems simple to you.

Re: Problem with calculation

Posted: Fri Mar 11, 2016 2:00 pm
by marac2203
And thank you all, finally calculation formula from previous posts works:

SKIPCHECK;
['HRK']= N: ['EUR'] *DB('Tečaj',!Period,!Scenarij,'EUR','Tečaj');
FEEDERS;
['EUR']=>['HRK'];



Thanks!

Re: Problem with calculation

Posted: Fri Mar 11, 2016 2:05 pm
by marac2203
I got one more problem with creting process that would calculate fakturiranost and nefakturiranost. Form me i'ts problem beacouse I never created such process with
calculation. Any ideas?

Re: Problem with calculation

Posted: Fri Mar 11, 2016 2:13 pm
by Edward Stuart
Can we assume you've read the Turbo Integrator Guide and that also did not help?
I've read rules guide, but it doesn't help.

Re: Problem with calculation

Posted: Fri Mar 11, 2016 2:35 pm
by marac2203
Better explanation: Fakturirano and Nefakturirano in cube Profitabilnost projekta must be calculated according to data from cube Radni sati and Tečaj

Re: Problem with calculation

Posted: Fri Mar 11, 2016 2:47 pm
by tomok
If you need to get data from a cube in a TI process you use the function CellGetN (or CellGetS if it's string). Suggest you read about it in the manuals,

Re: Problem with calculation

Posted: Fri Mar 11, 2016 8:50 pm
by babytiger
Edward Stuart wrote:Can we assume you've read the Turbo Integrator Guide and that also did not help?
I've read rules guide, but it doesn't help.
While I feel your pain for having to go through this as tm1 newbie, it is also worth pointing out that some basic fundamental tm1 train (and self learning) will go a long way.

You should not expect helpful people on the net to simply hand you the codes for every step/task you need to do or stuck on.