Concat Question

[#1]

Hi everybody,

I'm working on this Concat-formula and get again no result.

LOAD * INLINE [

Years
...,
2007,
2008,
2009,
2010

]

=max( concat( {$} distinct Years, ',') )

The result should be 2010.
you know what it is

[jonathandienst]

QJ

I stand open to correction on this, but as far as I can see

Max({$<Years={$(=(concat({$} DISTINCT Years,',')))}>}DISTINCT Years)

will return the same value as Max(Years), only more complex and less efficient. Am I missing something?

Jonathan

[#3]

Yes, you're right.
Years: 2001,2003,2006
If I need the Max value, then I can Max (Years) take. But if I need the second point, I think, i must work with Concat.
For example i need the Year 2003

Or is there another, better solution?......

[jonathandienst]

OK, but how are you selecting the year that you need?

[#5]

Many roads lead to rom and i chose the difficult road ahead

i select the years on the ListBox

Max(Years,2)
Max(Years,3)
...

I had to use this formula.
=Sum({$<Years={$(=max(Years,2))}>} sales)

Thanks for your help

[#6]

Hi,

The formula does not work. The concat is OK but when you set it as the argument of the rangemax, the result is null...