Summary field totals need to be set in a global field

[bonngo]

How can the totals from a summary field when sorted by "x" be set into a global field without doing any sort of an export? For example if the values of my summary field are 15, 40 and 100, I need to be able to do a "Set Field" to my global that will place those three numbers into it.

Thanks for any help!!!

Edited April 30, 2007 by Guest
removed all caps

[bruceR]

Welllll, that is exactly what the set field script step does after all.

[Søren Dyhr]

Provided you toss in a GetSummary( on righthand side - investigate it's utilization:

http://www.filemaker.com/help/FunctionsRef-341.html

--sd

[bonngo]

Thank you for your response. I have used the GetSummary function in the past, however, the problem I have now, is the function only places the first summary total in the global field. How can I have it repeat multiple times until all values are posted in the global field? This data will then be used for charts.

[Søren Dyhr]

Pretty straight forward:

http://www.kevinfrank.com/download/kf-fast-summary.zip

--sd