January 15, 201213 yr Unfamiliar with creating custom functions, I would like to return the value list with a count beside each item Let ( [ thelist = List ( diet::restriction ) ; vlist = ValueListItems ( Get ( FileName ) ; "diet_restriction" ) ] ; PatternCount ( thelist ; GetValue ( vlist ; 1 ) ) ) Inital List No Pork Vegetarian Vegan Return List No Pork 3 Vegetarian 2 Vegan 8
January 15, 201213 yr thelist = List ( diet::restriction ) ; Why not summarize the diet table by restriction, using a summary field?
January 15, 201213 yr Author Thanks Vaughan, that did the trick. Comment I wanted the function to set a field.
Create an account or sign in to comment