April 24, 200619 yr Newbies Alriiight...I've been working at getting a Percent of Total field to display subtotals as percentages of the final total (hence the fieldname). To derive this I have two Summary fields: SumTotalProblems and SumPerProblems. The former is a Count of the Primary Key field (ID) and the latter is a Fraction of Total of the Primary Key field (formatted as a percentage in the layout). The weirdness sets in when I run the report and sort based on the break field. I've included a screenshot of what happens and another of the table structure. Basically, it seems to calculate the value appropriately for 1/3 of my sample data. Does anyone know why this is happening? TIA, -Erik
Create an account or sign in to comment