I added tags to this post to increase visibility.
For your first question, my guess would be that there is an uncalibrated peak that is getting integrated which is not being displayed in your results table. To check this, right click on the table and select properties. In the properties window go to the Peaks and Repeating tab and check the 'Unknown Peaks' checkbox:
After displaying both identified and unknown peaks, is the Area% still not adding up to 100?
For the second question, can you give us an idea of the status of the report? Where are you getting stuck? Is the table not populating or can you just not get the sum of the groups' area% values to populate? Can you show a screenshot of what the report is doing?
Same answer as ryoboyle to your first question, or you have area rejection turned on in the table properties:
The answer to the second part of your question is to have a filter applied the table to show to show only peaks belonging to the groups, to then show you the sum of the area percentages of each group. You would have to create two tables, each with their own filter to show each of the group names.
Alternatively, you could repeat the same table for each group name. I think that would give you what you need.
Does that make sense?
Thank you both for the reply! I have applied the answer to the Area Percent Sum question to my report and I have to check further but I do think that worked.
Below you'll see some images that should clear up some of your questions :
In the top right table (Group & %) the value for column % is =Peak_AreaPercentand in the Summary Calculations tab I have checked the box Sum in order to populate the bottom row on the table.
As you can see, everything on my report is populating except for the values in the top right table, which I do have a filter set up for which is =4.
I hope this clarifies where I'm having the issue,
The Peak_AreaPercent field only applies to integrated peaks and not to compounds, meaning that ChemStation stores nothing is this field for Compound Groups. There is no built in field to calculate Area% for Compound Groups, so you will need to define an aggregator to store the Compound Group Area Sums and then use that aggregator in a custom expression to calculate the Compound Group Area%. I have illustrated how to define such an aggregator in the below screenshot:
Now that the aggregator (named GroupArea in this example) is defined, I can call it further down on my report in a custom expression to calculate the Group Area Percent, as seen below:
Hopefully this helps.
I created an invisible table above my Group table and put an Area Sum column in it with the aggregator defined.
Then, I went to my Group table and called out the aggregator in the value for Area %, just as you showed.
The good news is that did have some effect, but the value just reads 'Infinity' for both rows and it isn't letting me have a Sum on the bottom anymore.
Any ideas on why it's like that?
Your help is much appreciated.
Did you check to make sure that the denominator in the Area% expression ( Sum(GroupArea(Injection_OrderNo)) ) is returning a reasonable value? Does it match the sum of the Compound_AreaSum values in the hidden table that you used to define the aggregator?
And rather than copying my expression, I would recommend that you build it yourself using the available fields in the Expression Editor, just to make sure that you are calling your aggregator correctly.