Jump to content

portal calculations


RT
 Share

This topic is 5708 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello, i have just changed a layout from repeating fields to a join table with a portal, all works well as you can see by the demo.it adds the line items up. or advise me if there is a better way.

but i want to "sum" the total of all records, i have tried calc fields summarys but nothing works for me, and i cannot work it out. can some one please take a look and tell me where i am going wrong thank you.

Robert

expenses.fp7.zip

Link to comment
Share on other sites

If you create a new Cartesian 'X' relationship then you can reference the Summary field or sum it for the total of all the child records.

Link to comment
Share on other sites

I'm fully with John in his suggestions, further more have I made two mods of your file to show the various benefits of having related real summary fields and the use of aggregate functions.

The problem you discover with related summaries is that they won't freshen when ever you alter something in a portalline, and in order to give the right figures must a button issue a:

http://www.filemaker.com/help/ScriptsRef-269.html

I write this to pursuade you to use the ...fresh version of the templates attached. I have allowed my self to strain considerably in your fields, as well as removing the grand summary area.

--sd

expensesFresh.zip

expensesHang.zip

Link to comment
Share on other sites

Wow thanks for the help and showing me different ways to achieve the same result. at the moment i am using "comments" version as it it so easy to install, but i would like to use Sørens method so i will try this when i can work this out and i understand the logic. again thank you, Søren, Comment and Mr Vodka :waytogo:

RT

Link to comment
Share on other sites

This topic is 5708 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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