Max Value

[pablo]

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

[Duncan P]

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.

[pablo]

than you

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

[Duncan P]

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

[pablo]

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

thank you