No announcements
Found 2453674 threads
-
2 VotesSUM based on extra criteria?
, -- this assures data integrity, and tells the optimizer something alpha_amt DECIMAL(12,2) NOT NULL, beta_amt DECIMAL(12,2) NOT ...Answered | 6 Replies | 699 Views | Created by KuzeyInsel - Wednesday, April 4, 2018 4:32 PM | Last reply by --CELKO-- - Wednesday, April 4, 2018 7:20 PM
-
0 Votes
SUM in query criteria
I think Harshvai is correct, you'll need to move the aggregated expressions (any expressions using SUM) out of the WHERE clause and into the HAVING clause.Answered | 5 Replies | 3853 Views | Created by RockfieldNZ - Wednesday, September 14, 2011 3:41 AM | Last reply by RockfieldNZ - Thursday, September 15, 2011 1:07 AM -
0 Votes
syntax to sum individual records meeting certain criteria
posted.Value<>-1,round(sum(cdate(fields!Answered | 5 Replies | 3586 Views | Created by deeredealer - Saturday, May 19, 2012 7:39 PM | Last reply by Syed Qazafi Anjum - Monday, May 21, 2012 11:16 PM -
1 Votes
How to sum unique customer data based on criteria in powerpivot
= CALCULATE( SUM( payments[value], FILTER( payments, payment[status] = "Paid") ) To create bins you would use some form of dynamic ...Answered | 2 Replies | 629 Views | Created by AlexMartini - Thursday, July 7, 2016 11:31 PM | Last reply by AlexMartini - Tuesday, July 12, 2016 7:09 PM -
0 Votes
Sum Query based on date values
KhurramKZ, you had mentioned that you want to sum the value but you did not mentioned which values you want to sum.Answered | 7 Replies | 754 Views | Created by KhurramKZ - Wednesday, June 22, 2016 8:26 AM | Last reply by KhurramKZ - Friday, June 24, 2016 5:45 AM -
0 Votes
Count based on a Filter Criteria
This will return the last non-empty Quarter based on Net Income.Answered | 7 Replies | 3148 Views | Created by Rodrigo Sedano - Wednesday, October 10, 2012 2:50 PM | Last reply by Karthik Rangaraj - Thursday, October 18, 2012 9:07 PM -
0 Votes
Case Criteria
[date], GETDATE())Answered | 3 Replies | 697 Views | Created by RonTech1 - Saturday, February 10, 2018 3:14 PM | Last reply by Visakh16 - Saturday, February 10, 2018 4:17 PM -
0 Votes
Summing based on value of boolean
Because it could be different on how to count them.Answered | 5 Replies | 3936 Views | Created by mike950 - Wednesday, April 29, 2009 9:35 AM | Last reply by Isham H - Wednesday, April 29, 2009 2:36 PM -
1 Votes
Scheduling a report based on Criteria
Set them up exactly how you need with the parameters and recipients.Answered | 3 Replies | 827 Views | Created by ProfessorFudger - Thursday, April 9, 2015 1:19 PM | Last reply by Visakh16 - Thursday, April 9, 2015 4:26 PM -
2 Votes
COUNTING RECORDS IN A DATABASE BASED ON CERTAIN CRITERIA
I have been writing my project in VBA to produce word based reports from a database and have not explored queries and SQL.Answered | 3 Replies | 1501 Views | Created by MickYoung - Wednesday, August 8, 2012 7:43 PM | Last reply by MickYoung - Thursday, August 9, 2012 9:23 AM -
0 Votes
How to sum values based on parameter selection
Hi GOPAL92, Based on my understanding, if we select Jan, Feb and Mar from parameter drop down list, then we should sum the sales value corresponding to these ...Answered | 1 Replies | 477 Views | Created by GOPAL92 - Tuesday, January 31, 2017 9:02 AM | Last reply by Yuliana Gu - Wednesday, February 1, 2017 9:39 AM -
5 Votes
retrieve columns based on a criteria.
Hi, I have a requirement where I will have to populate the data based on a criteria for the below data.Answered | 9 Replies | 2780 Views | Created by pepcoder - Wednesday, January 4, 2012 12:20 PM | Last reply by RA-Singh - Thursday, January 5, 2012 5:33 PM -
2 Votes
How to Recursively Sum a Sum?
Learn how to follow ISO-11179 data element naming conventions and formatting rules.Answered | 14 Replies | 1852 Views | Created by ryguy72 - Thursday, July 10, 2014 6:48 PM | Last reply by ryguy72 - Wednesday, October 8, 2014 1:18 AM -
3 Votes
Sum of amount based on tags
Farook M, I modified the query to work in SQL Server 2008: Declare @Columns As VarChar(999) ,@ColumnsSum As ...Answered | 7 Replies | 781 Views | Created by Farook M - Friday, February 10, 2017 11:29 AM | Last reply by Mailson Santana - Monday, February 13, 2017 11:25 AM -
8 Votes
Sum the value of look up table based on two filter criteria
Hi Priyan, You can add a column in powerpivot which sums your 3 previous columns and then show it in your pivot table.Answered | 8 Replies | 1093 Views | Created by Priyan_Fdo - Monday, January 19, 2015 3:31 PM | Last reply by Priyan_Fdo - Tuesday, February 3, 2015 1:56 PM -
2 Votes
condition based sum measures in MDX
This is helpful. but using the linkmember i am getting deal value calculation where Effectivedate and Deal Date is equal. but how can get the sum of DealValue ...Answered | 3 Replies | 1566 Views | Created by Shanu_Shri - Wednesday, March 29, 2017 7:12 AM | Last reply by willson yuan - Wednesday, March 29, 2017 9:37 AM -
0 Votes
Count Unique Text Based on 2 Criteria
like you had mentioned the 3 steps. but you did not mentioned the criteria.Answered | 1 Replies | 452 Views | Created by ryguy72 - Wednesday, August 10, 2016 10:07 PM | Last reply by Deepak Saradkumar Panchal - Thursday, August 11, 2016 1:51 AM -
0 Votes
SSRS sum values based on condition
1) example the sum is giving a value of 62 which is correct.Answered | 4 Replies | 1749 Views | Created by HaroldDu - Friday, September 30, 2016 2:33 PM | Last reply by HaroldDu - Friday, September 30, 2016 7:52 PM -
3 Votes
How to modify data based on multiple criteria
As you have said you need to update a table base on excel data and another table.Answered | 5 Replies | 6409 Views | Created by Nancy Rickard - Wednesday, July 16, 2008 9:44 PM | Last reply by Chongtham Rajen Singh - Saturday, November 23, 2013 12:49 PM -
1 Votes
how to return number of record per match criteria
Try it with conditional summing: SELECT count(*) AS TotalCnt, sum(case when myField LIKE '%a%' then 1 else 0 end) AS Acnt, sum(case ...Answered | 2 Replies | 845 Views | Created by wakefun - Tuesday, September 10, 2019 11:25 AM | Last reply by Olaf Helper - Tuesday, September 10, 2019 11:38 AM - Items 1 to 20 of 2453674 Next ›
No announcements
