JustJoker Posted January 26, 2011 Share Posted January 26, 2011 Hello! I think I missed something. It should be simple. I've got 2 tables that are related. In the 1-st table -- Items, in the 2-nd one -- Parameters of Item with Amounts and DatesOfChange. I placed a portal into list-view layout to show Items with related Parameters (Amount) and filtered the portal by the Parameter's latest date of change. I need to calculate the sum of all filtered Amounts in the portal. I added a field in parent table with =sum(Amount) -- it shows the sum of all Amounts of all Parameters of the Item. Not filtered ones. I placed another portal with just one Total Summary field from child table and sorted it like the 1-st portal -- It shows just the amount of each record in the portal and changes when I click the fields. What am I doing wrong? Please, help!!! Link to comment Share on other sites More sharing options...
comment Posted January 26, 2011 Share Posted January 26, 2011 Rather hard to follow - an example file would be really useful. Link to comment Share on other sites More sharing options...
JustJoker Posted January 27, 2011 Author Share Posted January 27, 2011 That's the database. You see, in List layout I need to get 1040 as sum of all "Stop loss to prices". What am I doing wrong? Please, help! Sum Problem.fp7.zip Link to comment Share on other sites More sharing options...
comment Posted January 27, 2011 Share Posted January 27, 2011 OK, I see (hopefully...). A filtered portal is not a good approach to take here. Is it possible for a position to have more than one parameter on the same date? Link to comment Share on other sites More sharing options...
JustJoker Posted January 27, 2011 Author Share Posted January 27, 2011 Yes, It's possible. Actually, it's a timestamp field in the database (attached is just a sample course the original is not in English) Link to comment Share on other sites More sharing options...
comment Posted January 27, 2011 Share Posted January 27, 2011 Try it this way: Sum Problem.zip Link to comment Share on other sites More sharing options...
JustJoker Posted January 27, 2011 Author Share Posted January 27, 2011 Thank you very much. I've tried self-join but made a wrong relation. Thanks again. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4846 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