No announcements
Found 113387 threads
• 0 Votes

### SubTotal & GrandTotal Of Quantity & Amount

[Date],b.Item,b.Quantity,b.price,b.Amount,sum(Amount*Price) AS total FROM tbl1 a JOIN tbl2 b ON a.DocNo = b.DocNo GROUP BY grouping sets ((a.DocNo, a.
| 2 Replies | 95 Views | Created by Anonymous - Thursday, December 31, 2020 4:06 PM | Last reply by Anonymous - Friday, January 1, 2021 2:51 AM
• 0 Votes

### SSAS Custom MDX for SubTotal and GrandTotal in Cube

[Year - Period].allmembers on 1 from [TestCube] you will see that the measure for test1 is the same amount as ...
| 1 Replies | 2548 Views | Created by dear-microsoft - Monday, January 6, 2014 8:52 PM | Last reply by jon285 - Monday, January 6, 2014 9:40 PM
• 0 Votes

### SSRS GRANDTOTAL

Hi Naomi N Can you explain clearly this 'use some column to mark subTotal Rows and use conditional SUM to exclude these subTotal rows'.
| 10 Replies | 943 Views | Created by Chandrabose1 - Monday, September 7, 2015 10:02 AM | Last reply by Naomi N - Thursday, September 10, 2015 12:29 PM
• 0 Votes

### how to add subtotal/grandtotal using case and grouping sets?

I'd like to adapt it to rollup, cube and grouping sets (replace null with subtotal or grand total while not accidentally calling a null out as a ...
| 4 Replies | 2228 Views | Created by xxjergerxx - Monday, June 15, 2015 1:01 AM | Last reply by xxjergerxx - Tuesday, June 16, 2015 12:34 AM
• 0 Votes

### SUBTOTAL AUTOMATION

I created the following formula :           =if(a2=1(subtotal(9,a1))) But, it does n't work.
| 9 Replies | 1619 Views | Created by rjagathe - Saturday, October 6, 2012 12:03 PM | Last reply by rjagathe - Friday, October 12, 2012 3:57 PM
• 0 Votes

### Subtotal and percentage...

...
| 1 Replies | 3903 Views | Created by _Mimmi- - Wednesday, May 12, 2010 1:12 PM | Last reply by Parry2k - Wednesday, May 12, 2010 2:32 PM
• 1 Votes

### Rename GrandTotal Column

(When you are in the GrandTotal Excel menu you can choose to show or hide this kind of column.)
| 5 Replies | 1570 Views | Created by ms_bi_pete - Thursday, October 15, 2015 12:51 PM | Last reply by Michael Amadi - Sunday, December 20, 2015 8:50 AM
• 0 Votes

### Subtotal calculated expression from hidden detail row to subtotal row.

Hi donalejandro, According to your description, you want to make the detail rows toggled by the subtotal row, and when you hide detail rows the subtotal should get ...
| 1 Replies | 805 Views | Created by donalejandro - Monday, May 23, 2016 5:57 AM | Last reply by Xi Jin - Tuesday, May 24, 2016 7:42 AM
• 2 Votes

### Dynamics AX2012 Error Message (Quantity and amount must have same sign)

Error message "Quantity and amount must have same sign".
| 2 Replies | 3138 Views | Created by JBK99 - Friday, August 15, 2014 1:15 PM | Last reply by Just Karl - Monday, August 18, 2014 7:57 PM
• 2 Votes

### Query Help with subtotaling

Check out the following page on subtotal, total, grandtotal: http://www.sqlusa.com/bestpractices2005/subtotaltotalgrandtotal/ Also consider ...
| 6 Replies | 4009 Views | Created by nfpacct - Wednesday, September 1, 2010 9:17 PM | Last reply by Kalman Toth - Wednesday, September 8, 2010 9:55 AM
• 0 Votes

### Using Subtotal Function and Weighted averages

I want to develop a weighted average that calculates DOH looking at all stock for all plants such that when I subtotal by part number, the program does not average ...
| 2 Replies | 727 Views | Created by john searching for answers - Wednesday, January 28, 2015 5:34 PM | Last reply by Fei Xue - Thursday, January 29, 2015 6:01 AM
• 0 Votes

### Average of multiple group subtotals

I would try creating 1. a function in the report.Code section (right click in the report designer and click report properties, then code tab)Every time you call it, it will record ...
| 2 Replies | 838 Views | Created by Franco Lopes - Saturday, December 5, 2015 4:38 PM | Last reply by Visakh16 - Sunday, December 6, 2015 6:31 AM
• 0 Votes

### Gridview & client side subtotal and grandtotal calculations

User-650628323 posted Hi,  If you want to design Gridview to show subtotal and grandtotal, you can follow the link below which shows how to ...
| 1 Replies | 75 Views | Created by Anonymous - Monday, November 19, 2012 5:12 PM | Last reply by Anonymous - Friday, November 23, 2012 2:11 AM
• 0 Votes

### Turn off column subtotals but not row subtotals

Like if you have 4 years with months for columns, you can eliminate subtotals for individual years.
| 2 Replies | 699 Views | Created by AlexMartini - Friday, November 11, 2016 5:41 PM | Last reply by AlexMartini - Monday, November 14, 2016 11:58 PM
• 0 Votes

### Edit SubTotal And GrandTotal

And also the value will not be added into the GrandTotal.
| 5 Replies | 5734 Views | Created by tomigisi - Tuesday, July 31, 2007 5:22 AM | Last reply by tomigisi - Wednesday, August 1, 2007 4:26 AM
• 0 Votes

### Subtotal and Grandtotal are empty for culcalated member

Hi, I have problem on getting "column" Subtotal and Grandtotal for calculated member, it just show nothing on these two columns but "row" Subtotal and ...
| 0 Replies | 5146 Views | Created by Peterkllee - Thursday, August 2, 2007 11:36 AM
• 0 Votes

### SubTotals in SSRS

Hi, There is a way to do this without Custom Code, use this as the expression for your subtotal textbox.
| 10 Replies | 3165 Views | Created by Sanam K M N - Friday, May 3, 2013 11:31 AM | Last reply by Sanam K M N - Tuesday, May 14, 2013 9:24 AM
• 0 Votes

### question about program

TextWindow.Write("Please enter purchase amount:\$") purchaseAmount = ...
| 2 Replies | 616 Views | Created by gafler - Wednesday, March 5, 2014 9:06 PM | Last reply by gafler - Thursday, March 6, 2014 4:19 AM
• 0 Votes

### Facing problem with GrandTotal valule for calucated members.

[Incident Count])),0),  Visible = 1;   Wheile browsing the values in grand total also its calculating as ...
| 10 Replies | 2098 Views | Created by Madhu ML - Tuesday, August 7, 2012 11:17 AM | Last reply by Pavel Pawlowski - Wednesday, August 8, 2012 8:44 AM
• 5 Votes

### CALCULATE SUBTOTAL AND GRANDTOTAL IN DATAGRIDVIEW VB.NET

i + 2).Cells(4).Value = subtotal Next Dim grandtotal As Decimal = 0.0 For Each rw As DataGridViewRow In DataGridView1.Rows If ...
| 34 Replies | 6843 Views | Created by VBProgrammer_2020 - Tuesday, October 9, 2018 4:12 PM | Last reply by Tech Aspirant - Friday, October 12, 2018 11:25 AM
• Items 1 to 20 of 113387 Next ›
No announcements