No announcements
Found 2117065 threads
-
0 VotesSUM subset of columns by row
. Just for the record: our previous posts were concurrent; I was not reacting to yours. Actually, I've had a scenario where I had to sum across ...Answered | 9 Replies | 1085 Views | Created by DSXBX - Monday, August 28, 2017 2:31 PM | Last reply by Imke Feldmann - Monday, September 4, 2017 5:28 AM
-
1 Votes
How can i sum the columns row by row ?
I want to sum column row by row and update the sum for row Example ID QTY ...Answered | 6 Replies | 1168 Views | Created by Hemkoe - Thursday, July 31, 2014 9:43 AM | Last reply by Quest1234 - Wednesday, August 6, 2014 8:47 AM -
0 Votes
Sum a subset of the data
just add all of the start and end numbers. I need to sum those by property. I have tried several things using SUM and OVER and cannot seem to get the right ...Answered | 12 Replies | 7508 Views | Created by DeborahK - Monday, March 14, 2011 7:03 PM | Last reply by DeborahK - Monday, March 14, 2011 11:05 PM -
2 Votes
sum of group by two columns
(BillAmount) as [Total Billed] from Bills GROUP BY MemberID), ctePayments as (select MemberID, sum(PayAmount) as [Total Paid] from Payments GROUP BY ...Answered | 9 Replies | 3051 Views | Created by jacob gold - Wednesday, May 16, 2012 1:06 AM | Last reply by Naomi N - Wednesday, May 16, 2012 10:03 PM -
2 Votes
Conditional sum of columns
Hi all I have a data set that has 5 columns with values, e.g. sales week 1, sales week 2, ... , sales week 5. My user would like to look at the ...Answered | 3 Replies | 859 Views | Created by aikibart - Wednesday, March 14, 2018 10:47 PM | Last reply by Colin Banfield - Saturday, March 17, 2018 5:50 PM -
0 Votes
Sum of 2 columns
I have a report that shows the query below as 2 column, columns are time formatted, means for example it shows as 2:30 and 4:20, I like to have a third column that shows the sum ...Answered | 1 Replies | 3020 Views | Created by nikoo56 - Wednesday, February 22, 2012 5:45 PM | Last reply by Zilong Lu - Friday, February 24, 2012 8:51 AM -
0 Votes
Avoid sum of columns
layout,But when am dragging the 2nd dataset values into the report columns,its making the sum of those columns.( =Sum(Fields!Bill_count1.Value, ...Answered | 1 Replies | 3894 Views | Created by SSDL - Saturday, November 7, 2009 5:21 PM | Last reply by Jerry Nee - Tuesday, November 10, 2009 3:44 AM -
2 Votes
Sum of the columns in a row using CTE
1 END) AS 'FirstAnswers' -- sum of the first three columnsAnswered | 4 Replies | 3829 Views | Created by Pisqko - Friday, November 26, 2010 5:54 PM | Last reply by Pisqko - Friday, November 26, 2010 6:53 PM -
1 Votes
sum of columns
,subj3 int,total as sub1+sub2+sub3) httpAnswered | 5 Replies | 3719 Views | Created by MadanmohanT - Thursday, March 21, 2013 5:05 PM | Last reply by Allen Li - MSFT - Thursday, March 28, 2013 1:11 AM -
0 Votes
find sum of columns
'1/3/2010',5000,5 SELECT TID, TDATE, TAcNo, TAMOUNT ,RunningTotal = (SELECT SUMAnswered | 3 Replies | 2842 Views | Created by AllenIrani - Friday, January 27, 2012 4:05 PM | Last reply by Samuel Vanga - Friday, January 27, 2012 5:11 PM -
0 Votes
Sum of multiple columns
],'dd/MM') + ''')' FROM dbo.CalendarTable('20180101','20181231',0,0,0) ORDER BY [Date] FOR XML PATH('')),1,1,'') SELECT @Sql='SELECT SUM(val) ...Answered | 6 Replies | 463 Views | Created by valliammai26 - Friday, September 14, 2018 5:47 AM | Last reply by - Friday, September 14, 2018 9:58 AM -
0 Votes
Displaying subset of rows in a row
Display can be toggled by this report item. In the dropdown list, select the textbox which is header of Gate2.Answered | 7 Replies | 1522 Views | Created by Koti K - Friday, June 20, 2014 9:23 PM | Last reply by Koti K - Thursday, June 26, 2014 10:37 PM -
4 Votes
Sum of columns
Hi! I'm trying to sum a few columns of the same table, but it is giving a wrong answer. I want that my answer looks like: Municipality, Total ...Answered | 23 Replies | 6324 Views | Created by emeliz - Saturday, November 14, 2009 1:35 PM | Last reply by Melissa Suciadi - Tuesday, November 17, 2009 1:18 AM -
1 Votes
Sum of two Time columns
value with sum of minutes' columns. 3rd, after this I had one column that represented time in minutes. I divided it with 60 in one column, output ...Answered | 4 Replies | 1021 Views | Created by DannyNS - Friday, March 24, 2017 9:24 AM | Last reply by DannyNS - Monday, April 10, 2017 9:22 AM -
0 Votes
Sum of calculated columns?
.DTStep) FROM @Budget b3 WHERE b3.SalesOrder = b.SalesOrder) THEN ...Answered | 3 Replies | 5245 Views | Created by MindReign - Thursday, June 5, 2008 9:48 PM | Last reply by AlunJ - Thursday, June 5, 2008 10:00 PM -
4 Votes
DataFormWebPart Sum of Currency Columns
I have a data form web part with the "sharepoint list with currency columns" data source. I have added a footer to sum the rows. It seems like because of the ...Answered | 7 Replies | 16341 Views | Created by Nik Patel - Sunday, September 12, 2010 6:24 PM | Last reply by Norgewalk - Wednesday, May 23, 2018 10:35 PM -
0 Votes
Sum value of above row
no idea how to set expression in reportviewer to calculate the "Balance" column in each row that it will sum the value of previous row ...Answered | 1 Replies | 6324 Views | Created by joeyan829 - Friday, March 11, 2011 1:17 AM | Last reply by Russ Loski - Friday, March 11, 2011 1:53 AM -
0 Votes
Calculate Sum of all Rows and Columns
Hello, How would I go about calculating a sum of the combined rows and columns? Currently, the only way I know how to do this is by naming the ... -
0 Votes
group and sum of columns
for whatever reason I had to create the list over again. However, I can't format my [SUM] as .7 instead of 70.00 I have to divide it by 100Answered | 6 Replies | 1674 Views | Created by SharePointGuy123 - Tuesday, March 18, 2014 7:40 PM | Last reply by star.wars - Friday, March 28, 2014 10:30 AM -
0 Votes
Sum of Columns as Rows
lab2 values(7,8,9) SELECT newcol1,newcol2 FROM (SELECT SUM(col1) as sumcol1, SUM(col2) as sumcol2, SUM(col3) as sumcol3 FROM ...Answered | 3 Replies | 5036 Views | Created by ZedBee - Tuesday, August 23, 2011 3:07 PM | Last reply by Velmurugan.S - Thursday, August 25, 2011 9:06 AM - Items 1 to 20 of 2117065 Next ›
No announcements
