Jump to content
Sign in to follow this  
bonngo

Summary field totals need to be set in a global field

Recommended Posts

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 by Guest
removed all caps

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

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

--sd

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.