If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum Top Values
My report displays the top 15 values of [NetofReturns]. I have a counter
that begins a new page after the 15th value in the detail section. In the group footer, I need to display the sum of those 15 values along with the group sum =sum([netofreturns] and a calculation of the percentage that the top 15 make up of the group sum. The group sum is not a problem but the sum of the top 15 is. I can display the running sum of the Top 15, but I can't get that 15th sum into the footer. |
#2
|
|||
|
|||
Sum Top Values
pcaguy wrote:
My report displays the top 15 values of [NetofReturns]. I have a counter that begins a new page after the 15th value in the detail section. In the group footer, I need to display the sum of those 15 values along with the group sum =sum([netofreturns] and a calculation of the percentage that the top 15 make up of the group sum. The group sum is not a problem but the sum of the top 15 is. I can display the running sum of the Top 15, but I can't get that 15th sum into the footer. Just reference the top15 value in a group footer text box: =txtTop15 If you are having trouble calculating the top 15 value over the entire group, then set the txtTop15 running sum text box's expression to: =IIf(txtLineCounter = 15, NetofReturns, 0) where txtLineCounter is the =1 running sum text box that you are using to determine when to start a new page. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Sum Top Values
Thanks. That's what I needed.
"Marshall Barton" wrote: pcaguy wrote: My report displays the top 15 values of [NetofReturns]. I have a counter that begins a new page after the 15th value in the detail section. In the group footer, I need to display the sum of those 15 values along with the group sum =sum([netofreturns] and a calculation of the percentage that the top 15 make up of the group sum. The group sum is not a problem but the sum of the top 15 is. I can display the running sum of the Top 15, but I can't get that 15th sum into the footer. Just reference the top15 value in a group footer text box: =txtTop15 If you are having trouble calculating the top 15 value over the entire group, then set the txtTop15 running sum text box's expression to: =IIf(txtLineCounter = 15, NetofReturns, 0) where txtLineCounter is the =1 running sum text box that you are using to determine when to start a new page. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|