liltbrockie Posted February 5, 2014 Share Posted February 5, 2014 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 Link to comment Share on other sites More sharing options...
comment Posted February 5, 2014 Share Posted February 5, 2014 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. Link to comment Share on other sites More sharing options...
liltbrockie Posted February 7, 2014 Author Share Posted February 7, 2014 Cool! Thanks Comment! Link to comment Share on other sites More sharing options...
comment Posted February 7, 2014 Share Posted February 7, 2014 Cool! Thanks Comment! No problem, glad I could help. 1 Link to comment Share on other sites More sharing options...
Raybaudi Posted February 7, 2014 Share Posted February 7, 2014 Cool! Thanks Comment! Here is the function anyway in case anyone else is searching!: That function, as written, can't work. Link to comment Share on other sites More sharing options...
comment Posted February 7, 2014 Share Posted February 7, 2014 That function, as written, can't work. Why such a negative attitude? Link to comment Share on other sites More sharing options...
Rick Whitelaw Posted February 7, 2014 Share Posted February 7, 2014 What function? Can't see it. Link to comment Share on other sites More sharing options...
liltbrockie Posted February 7, 2014 Author Share Posted February 7, 2014 It has gone at the request of the author Link to comment Share on other sites More sharing options...
Lee Smith Posted February 7, 2014 Share Posted February 7, 2014 It has gone at the request of the author OMG, now you got my curiosity up, what was the name of this custom function Link to comment Share on other sites More sharing options...
Raybaudi Posted February 9, 2014 Share Posted February 9, 2014 Why such a negative attitude? There was an undefined $var in that custom function ( at least ) Link to comment Share on other sites More sharing options...
eos Posted February 9, 2014 Share Posted February 9, 2014 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 Link to comment Share on other sites More sharing options...
LaRetta Posted February 10, 2014 Share Posted February 10, 2014 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. Link to comment Share on other sites More sharing options...
Raybaudi Posted February 10, 2014 Share Posted February 10, 2014 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3729 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now