TM1 Forum

Hi all!

i have a trouble when i write the rules from Excel in TM1
i have 5 year like the Dimension below:
https://plus.google.com/u/0/photos/1114 ... oOkp5vOsgE

and i want get Min in the row, if i used fomula Min(a,b,c) it have too much cell (a,b,c .....) i need list
fomular in Excel: D18=MIN(D17:$BV$17)

please hepl,

thanks alot!

blusky_1010 wrote:Hi all!

i have a trouble when i write the rules from Excel in TM1
i have 5 year like the Dimension below:
https://plus.google.com/u/0/photos/1114 ... oOkp5vOsgE

and i want get Min in the row, if i used fomula Min(a,b,c) it have too much cell (a,b,c .....) i need list
fomular in Excel: D18=MIN(D17:$BV$17)

please hepl,

thanks alot!

Has having a (thorough) read through of the developer guide and reference manual occurred to you? It would be highly recommended.

There's no easy way of getting a minimum/maximum from a range of cells in TM1. You can only get the minimum/maximum of 2 numbers.

If you want to get a min/max of a range of numbers, you're probably better of using a TI to pass through the cells and using if statements to extract the minimum.

It is possible to do with rules but you'd have to have a cube with a duplicate dimension and use an if statement to compare every number with every other number, which is pretty messy and would be pretty slow if it was anything but a very small dimension.

I notice that OP is on v10. In this case the ConsolidatedMin and ConsolidatedMax functions are available. These have not always been readily to hand in the documentation so he can be forgiven for not finding them. They are described here and discussed here. They are valid both in rules and TI as mentioned in the referenced thread.

whitej_d wrote:There's no easy way of getting a minimum/maximum from a range of cells in TM1. You can only get the minimum/maximum of 2 numbers.

If you want to get a min/max of a range of numbers, you're probably better of using a TI to pass through the cells and using if statements to extract the minimum.

Any example to do this?

Thanks,

Hi luisda ,Any reason for not trying ConsolidatedMin and ConsolidatedMax functions as suggested by Duncan P? Thanks