August 21, 201015 yr FM 11 advanced, Win Vista Iâm having trouble with summary data in FM 11. I have a layout that sorts by the correct break fields, but 1) the summary totals in the subsummary part are incorrect, (they display the last value in the column, not the total), and 2) an extra âtotalâ shows up in browse and preview modes near the below the last subsummary part. Iâve attached a file showing views of the preview and layout mode. The break field âcategoryâ is a related field. I donât know if this is the problem. The body part contains the cost data. I know that in FM 11 you can view the subsummary data in browse mode. Could this be responsible for âtotalâ appearing at the bottom of the sheet. How can I stop this?
August 21, 201015 yr It's hard to tell without seeing the file, but it seems you have the same field (Budget) in both the body part and the subsummary part. The subsummary part should show a summary field defined as Total of Budget. As for the extra total at the bottom, check your data - it looks like you have some empty records there.
August 21, 201015 yr Author Yes, there was an extra record. Thanks for your help. How can I attach the FM file so you can see it?
August 21, 201015 yr Author The FM file is attached.The layout in question is "Budget for previous year". Budget_Planner_2011.zip Edited August 21, 201015 yr by Guest
August 21, 201015 yr The layout in question is "Budget for previous year". There is no such layout, but I did find the "Baseline Cost Data Input" layout and the problem there is exactly as stated in my first post. Change the field in the subsummary part from Budget to BudgetSum.
August 22, 201015 yr Author That did it. Thanks for your help. I feel like a dummy making such an amateur mistake. Back to FM 101!
Create an account or sign in to comment