Improve company productivity with a Business Account.Sign Up

x
?
Solved

Cognos promp dates

Posted on 2014-01-01
3
Medium Priority
?
289 Views
Last Modified: 2014-01-31
Hi,

I developing a report which requires to read from balance table it gives yesterday value which is fine, but I want also to read balance one day before.

what is the expression to use? or is there any other way or shortcut?

Thank you.
0
Comment
Question by:amq10
  • 2
3 Comments
 
LVL 12

Expert Comment

by:Habib Pourfard
ID: 39750164
we need more details. please let us know about the query you are using.
0
 

Accepted Solution

by:
amq10 earned 0 total points
ID: 39751187
thank you Pourfard.

the query I want to run is like this as I drag from package data items:

customer number
customer name
account balance amount  ( I expect output to show balance as yesterday which is fine)
account balance amount  -1 Day ( not included package data items).

I hope this can help.
0
 

Author Closing Comment

by:amq10
ID: 39823520
it works with some tricks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…

584 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question