Is it possible? Sorted data within a List (field) function

[ino]

Please help.

[color:red]1. Sort within a function LIST (Field)

2. Isolating the first 8 (the largest or smallest value)

Is able to sort the data received from the Aggregate function LIST (field)?

How to sort or is there possibility to sort the data obtained with the function LIST (field) from smaller to larger, or vice versa? The data in the function list are unstable.

Custom functions or?

The result of LIST function is:

234

223

246

219

237

244

245

258

238

211

233

220

252

227

229

243

257

263

239

230

255

242

268

217

265

I need:

268

265

263

258

255

257

252

246

245

244

243

242

239

238

237

234

233

230

229

227

223

220

219

217

211

After sorting needs 8 most value within the List functions:

268

265

263

258

255

257

252

246

Thanks in advance,

Ino

PS.

FileMaker Pro 10 Advaced

Sorry for my english ...

[bruceR]

Where does the list come from? There are various ways to do this, including custom functions:

http://www.briandunning.com/filemaker-custom-functions/results.php?keyword=sort

But why not get the list as sorted originally?

[comment]

The List() function returns values sorted by the sort order of the relationship.

[ino]

BruceR,

Thanks for fast reply, but research Brian’s CF.

Problem is that I grab List ([color:blue]field) from repeating field (39 repetitions), then i I use data inside Custom function RemoveDuplicates ( List ([color:blue]field) ) and result is:234¶223¶219¶237¶244¶245¶258¶238¶211¶233¶220¶252¶227¶229¶243¶257¶263¶239¶230¶255¶242¶268¶217¶265

not sorted. Any how I need this List (field) to be sorted.

Ino :thumbup:

[ino]

Commnet,

Thanks for Your very fast reply, pls. read my previous replay to BruceR

Ino

[comment]

So why not use a related table instead of the repeating field? The way you're going, you would need another custom function to sort the values (or a combined custom function to do both).

---

BTW, with a self-join relationship matching on SerialID, you can use a value list (related values only) to de-dupe AND sort the list, even with the repeating field.

Edited May 8, 2010 by Guest

[ino]

Comment once again,

Thanks for fast reply,

What I am trying to do with this DB is to analyze the Lotto winnings of national lotteries from 1990 until today.

So I stored gains (7 / 39) for all years. I have repeating field (rep 39 times) and if repeating number of fields is equal to the drawn number (Extend (D1) ... Extend (D7) = Repeating number) add the calculation of the indicator (ID = 1), then adds the color for the conditional format to drawn numbers.

In summary Field (repeating field, x 39) takes the Total of each repetition and getting a result in the Grand Total. Through various Subtotal control the gains (the numbers drawn in each round) per month, the day the draw, year.

The only thing missing that should be that in CONDITIONAL FORMAT to get 7 or 8 or 9 or x most times the numbers are drawn in a different color (background) or that these numbers are in bold and other text color.

Attachment PNG clip window.

How? :qwery:

INO

[bruceR]

BruceR,

Thanks for fast reply, but research Brian’s CF.

Problem is that I grab List ([color:blue]field) from repeating field (39 repetitions), then i I use data inside Custom function RemoveDuplicates ( List ([color:blue]field) ) and result is:234¶223¶219¶237¶244¶245¶258¶238¶211¶233¶220¶252¶227¶229¶243¶257¶263¶239¶230¶255¶242¶268¶217¶265

not sorted. Any how I need this List (field) to be sorted.

Ino

And the problem is ... what? There are lots of ways to approach this including getting rid of repeats. But the Brian Dunning site provided a DIRECT solution so I do not understand what you consider the problem to be. There are several custom functions for sorting lists. Pick one.

[comment]

analyze the Lotto winnings of national lotteries

It's a futile attempt IMHO, but if you're going to do it anyway, at least do it right:

Draws -< WinningNumbers >- Numbers

Then you can sort and summarize the results any way you like. This will be MUCH faster than using custom functions for sorting and/or removing duplicates.

[ino]

BruceR,

The problem is that I tried a few custom functions from Brian's db, but no one CF (which I use - tested) in the field ABS_MAX don’t give me sorted data in the List (field) or ascending or descending.

Will You be so kind to suggest one.

ino

[bruceR]

No, I can't really give a suggestion, except to say that as far as I know they all work.

There is some other problem with how you're using them. You'll need to post an example file. But Comment is making the better suggestion; get rid of the repeating fields.