TM1 Forum

Hi,

I have tried the max function ans read this post: http://www.tm1forum.com/viewtopic.php?f=3&t=4207, but cannot manage to get this working.

I upload seconds per item for an invoice. I need to calculate adj seconds.

For the adjusted seconds I want to put the maximum seconds per item per invoice next to each item.

Item Seconds Adj Sec
A 5 7
B 3 7
C 7 7

The adjusted seconds for each item on invoice X will be 7 sec per item.

There are other dimension in cube as well but the link is invoice and item.


I have tried:

['Adj Sec']=N:MAX(['seconds']);


['Adj Sec']=N:
MAX(DB('Despatch_Stageing',!DC,!Invoice Number,!Equipment Type,!Branch,!Item,!Supplier,!Activity,'Seconds'));

['test sec adj']=N:
IF(ELLEV('Item',!Item)=0,
Max(DB('Despatch_Stageing',!DC,!Invoice Number,!Equipment Type,!Branch,!Item,!Supplier,!Activity,'Seconds')),continue);


Am I heading in the right direction or should I try something different.

I am not able to save any of these rules above.

Thank You in advance

If you are in 9.5.2 and above look at the ConsolidatedMax function. The MAX that you are using just give the maximum of two numbers.

than you

will try that, but I know that this function is very resource intensive.

That is not true. It uses feeders and works from the leaf elements in the same way as normal in-built consolidation. It is very different in that respect from ConsolidateChildren

that is correct. my mistake. consolidatechildren is the bugger. will never use that again.

thank you