Viewing 11 posts - 1 through 11 (of 11 total)
Thank you, i think i am losing my skills!! 🙂
December 21, 2011 at 8:40 am
the values 888,123 etc... we have about 100,000 distinct values, so that way will not work.
June 21, 2011 at 4:00 pm
I have resolved this problem by giving the report only a permission of "everyone" and setting the url to the report directly.
June 8, 2011 at 4:03 pm
Garadin (4/12/2011)
Replace
SUM(trxquantity) / SUM(trxcount) AS [UPT]WITH
CASE WHEN SUM(trxcount) > 0 THEN SUM(trxquantity) / SUM(trxcount) ELSE 0 END AS [UPT]
Thank you this worked perfectly !!
April 12, 2011 at 8:21 am
GSquared (1/31/2011)
What defines an "empty target"?You're giving WAY too little data here to be able to help you on this.
a "NULL" defines an empty target
January 31, 2011 at 8:50 am
Thank you for the person who gave me the answer;
SUM(CASE WHEN Department in ('SOUH', 'DIAM', 'JEWR') THEN TrxFullPrice
ELSE 0
END) AS SOUH
January 5, 2011 at 7:04 pm
No this will not work.
maybe doing a union on separate case statements?
January 5, 2011 at 6:59 pm
GSquared (10/21/2010)
Why are you using a subquery for the final column? Why not just move "where i.[record type] = 'overall'" into the Where clause of the main query?
That was...
October 21, 2010 at 2:11 pm
I believe i got the answer.
I do not know why this works but by placing the SLPRSNID = '104' instead of 104 works !!
Thanks !!
September 13, 2010 at 12:34 pm
Viewing 11 posts - 1 through 11 (of 11 total)