hello everyone i'm having a rather painful problem.
I would like to have three columns on a report. 1st column will add the total amount when the invoice number is starts with 'tr' second column has amount and third column has count of those invoices that have tr. This is not the problem that...
I finally Figuered this one out!!! BOY im i excited ;D here is what i had to do.
I created a union then i added some data items in addition to a little case statement
CASE
WHEN (_days_between({sysdate},[INVOICE_DATE])) between 0 and 30
Then ([Union2].[APPROVED_AMOUNT])
ELSE (NULL)
END
Hope...
I dont think i have been very clear here is the datediff function I use to calculate the difference between the invoice date and the current date.
I have a column called approved amount. What i would like to do is just show the amount when the column meets the criteria below...
thanks for the response i guess my question is should i be puttiing this case statement on the expression of the column? Thats where im having a hard time understanding. Where do i put case statements in cognos besides filters?... Sorry if i'm having a hell of a time understanding here. and...
Hello everyone I apologize if this sounds like a stupid question however I'm a noob to cognos. but what im trying to accomplish with cognos would seem to me very doable. I Have a report that runs base on a calculation filter using the datediff function. It basically calculates the Difference of...
Hello everyone. Thanks for all the replies however i couldn't get my previous code to work but i figured out a different way to get this done. I will posted here in case someone else ever runs into this problem. As XLBO mentioned you cant use "destination" with different workbooks therefore i...
thank you everyone for your help. yes both sheets are opened however now i get the object dosent support this property or method.
Destination:=.Range("A" & .Rows.Count).End(xlUp).Offset(1, 0)
sht.Range("a1:al1").Copy _
Destination:=wb.Sheets("aui01").Range("A1").End(xlUp).Offset(1, 0)
Next sht
i still keep getting a subscript out of range here? wich i havent been able to figure out. Can anyone help?
I have a few sheets on 1 workbook and would like to copy all the contents of those sheets onto the last used cells of another workbook. im sure is something small im missing. here is my code. Any help would be greatly appreciated.
i cant get it to run i keep getting a object variable problem...
Thank you glenn thats exactly what i needed sometimes a small detail scapes me and i spend endless hours working on a project. Also my apologies on putting this post on the wrong part forum.
I've i have 3 worksheets that have about 64k lines and i like to run my macro on all the worksheets. Here is my code those anyone see what im doing wrong?
Dim ws As Worksheet
For Each ws In Worksheets
Columns("A:A").Select
Selection.TextToColumns Destination:=Range("A1")...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.