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

 

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.

Cool! Thanks Comment!

Cool! Thanks Comment!

 

No problem, glad I could help.

Cool! Thanks Comment!

 

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

 

 

That function, as written, can't work.

That function, as written, can't work.

 

Why such a negative attitude?

What function? Can't see it.

It has gone at the request of the author

It has gone at the request of the author

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

Why such a negative attitude?

 

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

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

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.

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.