No announcements
Found 3191218 threads
-
0 Votes
SharePoint 2013 lookup functions
Title is being used normally as user need to identify the data before they select.Answered | 6 Replies | 1652 Views | Created by jazz_dog - Thursday, January 22, 2015 7:01 PM | Last reply by Vincent.Han - Monday, January 26, 2015 1:35 AM -
0 Votes
SQL SUM function
date1) AND (column_with_a_dateAnswered | 2 Replies | 4096 Views | Created by ricky_m - Monday, July 5, 2010 4:13 PM | Last reply by ricky_m - Tuesday, July 6, 2010 8:22 AM -
2 Votes
stuck on syntax error - compute sum() function
That sorta works Erland, thanks.Answered | 12 Replies | 14440 Views | Created by sameeroquai - Tuesday, July 3, 2012 6:42 PM | Last reply by Peter_D503 - Monday, November 5, 2012 10:47 PM -
0 Votes
Tabular Model Lookup Function
Is there some generic guidelines which can help us decide what to do when which will work without cause performance issues ?Answered | 6 Replies | 3727 Views | Created by Sanjay Lallubhai Shah - Friday, November 2, 2012 1:29 PM | Last reply by Christian Wade - Monday, November 5, 2012 5:46 PM -
0 Votes
SSRS 2005: SUM function not behaving as expected
I have found that I need to have either the list or table reside in a sub report and that I pass in the data that is needed.Answered | 6 Replies | 4073 Views | Created by VB.Net Pro - Tuesday, September 15, 2009 9:09 PM | Last reply by Jim Rasmussen - Wednesday, September 16, 2009 9:35 PM -
0 Votes
SUM function for multiple conditions?
Right now, I am doing something like this: Select Col1 ,Col2 ,Col3 ,SUM(Case When T1.Status = 'Active' Then 1 Else 0 End) As ...Answered | 3 Replies | 2288 Views | Created by SqlCraze - Monday, January 28, 2013 3:57 PM | Last reply by SqlCraze - Monday, January 28, 2013 4:22 PM -
0 Votes
SUM() function issue ?
So you are seeing Ist sum as 20 instead of 10.Answered | 16 Replies | 1817 Views | Created by Maggy111 - Thursday, September 13, 2012 8:58 AM | Last reply by Naomi N - Friday, September 14, 2012 12:34 PM -
0 Votes
Need custom code to sum the first row in a group in SSRS
I think you can do similar calculation through embedded code but does it really required?Answered | 3 Replies | 6061 Views | Created by ATRSAMS - Thursday, June 7, 2012 3:31 PM | Last reply by Syed Qazafi Anjum - Friday, June 8, 2012 9:07 AM -
0 Votes
Does InScope function work inside Aggregate
Suppose I write expression like this, =IIF(InScope(scope), call function GetValue for hashtable1, call function GetValue for ...Answered | 10 Replies | 6393 Views | Created by sisvis Allscripts - Monday, April 25, 2011 12:35 PM | Last reply by sisvis Allscripts - Tuesday, May 10, 2011 5:35 AM -
0 Votes
lookup columns does not work when list stp to different server
When we save the list as a template and uploaded the stp file to a different server, create a list with the list template, the look up columns can't get ...Answered | 2 Replies | 1073 Views | Created by exploreIT - Monday, March 2, 2015 10:42 AM | Last reply by Lisa Chen1226 - Tuesday, March 3, 2015 10:24 AM -
0 Votes
Does SSIS lookup work like inner join
Hi I run this in SQL we get 2 values (rows) for t=2 returned in the recordset: create table t1 (t ...Answered | 2 Replies | 13653 Views | Created by BIfool - Friday, July 8, 2011 10:35 AM | Last reply by Jamie Thomson - Friday, July 8, 2011 10:46 AM -
0 Votes
Using Me.Value in Lookup Expession Not Working
ME.VALUE is a function, that returns the value of the textbox in wchich this expression occurs.Answered | 2 Replies | 1632 Views | Created by BigRoy00 - Thursday, May 28, 2015 3:11 PM | Last reply by Profesornia - Thursday, April 6, 2017 12:25 PM -
0 Votes
SSRS 2008 using lookup to get data from different dataset(s) , will it affect the group sums in the main tablix?
In our local environment, we have tested this scenario and the report works properly.Answered | 1 Replies | 631 Views | Created by shiftbit - Wednesday, September 23, 2015 3:41 PM | Last reply by 王者荣耀 - Thursday, September 24, 2015 8:15 AM -
0 Votes
Sum function on SQL report Builder
=Sum(iif(fields!Answered | 4 Replies | 2203 Views | Created by userIS901 - Monday, October 8, 2012 10:50 AM | Last reply by Charlie Liao - Monday, October 15, 2012 8:47 AM -
0 Votes
Conditional Sum Function - works on level 1, but not on level 2
I found that I needed to force Fields!Answered | 4 Replies | 1045 Views | Created by vsla - Saturday, December 19, 2015 1:26 AM | Last reply by vsla - Monday, January 25, 2016 4:20 PM -
0 Votes
Nested functions, Sum of Last(mailboxcount)
If I do a SUM of all the samples it would be incorrect.Answered | 12 Replies | 2053 Views | Created by Ijaz Kazi - Saturday, June 7, 2014 2:25 PM | Last reply by Ijaz Kazi - Thursday, June 12, 2014 5:06 PM -
0 Votes
ReportViewer SUM Aggregate function shows #ERROR
Actually i faced those problem many times, but i used the same type of expression it worked fine, I will try to find solution for this.Answered | 4 Replies | 8188 Views | Created by kurobenko - Tuesday, November 3, 2009 8:40 PM | Last reply by kurobenko - Tuesday, November 10, 2009 12:42 AM -
0 Votes
Sum Aggregate in Tablix
Since the aggregate function cannot be used in a lookup function, we need to rewrite the query of the datasets that map to Tablix1 and Tablix2 to get the summary of ...Answered | 5 Replies | 2837 Views | Created by Mpumelelo S - Monday, June 25, 2012 11:42 AM | Last reply by Syed Qazafi Anjum - Tuesday, June 26, 2012 8:13 AM -
0 Votes
Need help in getting the sum of a grouping value in a report
Hi Arun, Thanks a lot it worked for me...Answered | 5 Replies | 1919 Views | Created by Sreekanth K - Monday, October 29, 2012 9:10 AM | Last reply by Sreekanth K - Monday, October 29, 2012 2:47 PM -
0 Votes
Multiple IIFs to SUM a field?
As i can understand, you need to fill sum, if two conditions are appear, so instead of =IIF((IsNothing(Fields!Answered | 2 Replies | 849 Views | Created by LawrensonR - Tuesday, September 13, 2016 10:16 AM | Last reply by xjomanx - Wednesday, September 14, 2016 12:20 PM
No announcements