
1. Re: Calculations
crtopher Jul 1, 2012 1:34 AM (in response to AmilValladarez)Sounds like you need a new calculation field  GetSummary; Total with break field of Category 
2. Re: Calculations
GuyStevens Jul 1, 2012 5:42 AM (in response to AmilValladarez)Is your list already sorted by category? And do you have a subsummary field when sorted by Category?
If so you might want to add a trailing subsummary part when sorted by Category and put the sum total field in that trailing sub summary part.
Note that you only see subsummary parts when the records are properly sorted.

3. Re: Calculations
AmilValladarez Jul 1, 2012 3:16 PM (in response to AmilValladarez)@Chris & DaSaint: Both of your suggestions worked. I have the sum total field in the right layout part. Now, I'm having trouble with the calculation formula. The amounts are not being added up correctly per individual category.

4. Re: Calculations
AmilValladarez Jul 1, 2012 4:29 PM (in response to AmilValladarez)Update: I just found the solution to my problem. The sum total field is in the right place and showing the right number. Thanks for helping me out, Chris & DaSaint.

5. Re: Calculations
crtopher Jul 1, 2012 4:30 PM (in response to AmilValladarez)Hi Larry  you shouldn't need to do both. If you have a layout with a subsummary based on Category, you have a normal total summary field, and you sort the layout by category (amongst other things), then you don't need the GetSummary calc. Just try doing it one way. You only need the getSummary calc if you can't have a layout subsummary poart based on Category, or you can't or don't want to sort by Category.