Grouping and summing a list

[liltbrockie]

Hi there...! Calling all Custom Function wizards I need your help!!

 

I am trying to make a custom function that can take a list of values like so:

 

Bob|5

Mary|3

Anne|3

Bob|5

Frank|1

Bob|5

Anne|2

 

 

And turn it in to a group summed list like this:

 

Bob|15

Mary|3

Anne|5

Frank|1

 

[comment]

Sorry, this is a non-question. The real problem lies elsewhere. Why don't you use records and fields to store your data? Then the problem of summing and grouping becomes trivial.

[liltbrockie]

Cool! Thanks Comment!

[comment]

Cool! Thanks Comment!

 

No problem, glad I could help.

[Raybaudi]

Cool! Thanks Comment!

 

Here is the function anyway in case anyone else is searching!:

 

 

That function, as written, can't work.

[comment]

That function, as written, can't work.

 

Why such a negative attitude?

[Rick Whitelaw]

What function? Can't see it.

[liltbrockie]

It has gone at the request of the author

[Lee Smith]

It has gone at the request of the author

 OMG,  now  you got my curiosity up,  what was the name of this custom function

[Raybaudi]

Why such a negative attitude?

 

There was an undefined $var in that custom function ( at least )

[eos]

There was an undefined $var in that custom function ( at least )

 

Look closer … 

 

In fact, I learned this from you, though not in this exact manner.

GroupAndSummarize_eos.fmp12.zip

[LaRetta]

Sorry, this is a non-question. The real problem lies elsewhere. Why don't you use records and fields to store your data? Then the problem of summing and grouping becomes trivial.

 

Well, in comparing whether to use a proper relationship with records versus a custom function, my vote is the relationship. 

And I have to say that I'm surprised that other seasoned developers on this thread aren't supporting the same concept.

[Raybaudi]

Look closer … 

 

I did. 

I have to say that I was wrong but also that your CF shows a difficult sequence, although the result is nice.