Folks,
I need some thoughts on this .
Do update. Anything would do to get the results, anything from Multiple data providers, "Do not generate SQL", defining a variable, having prompts to fetch the result set of data in the report or using "UserResponce" functions. Get me something on which i can improvise.
Need help.!!!!
Thanks.
Thread: Always take 6 months history to calculate forcast  |
|||||||||||||
|
Started 3 months, 4 weeks ago by adnan
Hi,
In most basic words, this is what i need. In-order to project values from current month going forward till the end of current year, i need to consider 6 months historical data(based on current month).
How should i go about doing a cross-tab report where i need to show current year values only, with <Actual> from start of the year till end of previous month and <Forcast>(...
|
|
||||||||||||
|
|||||||||||||
Other posts in this thread:
adnan replied 3 months, 4 weeks ago
Size: 491 bytes
Customize: 
shiva.tomar replied 3 months, 3 weeks ago
to get the current year value you can put a where condition where year = 2009
or
Code: year = formatdate(currentdate();'YYYY') This is to get the current year.
To calculate past 6 month from current date:
Code: =formatdate(add_months(currentdate();-6);"your format")
If you wanna have the begining of past 6 month then
=...
Size: 1,237 bytes
Customize:
shiva.tomar replied 3 months, 3 weeks ago
to get the current year value you can put a where condition where year = 2009
or
Code: year = formatdate(currentdate();'YYYY') This is to get the current year.
To calculate past 6 month from current date:
Code: =formatdate(add_months(currentdate();-6);"your format")
If you wanna have the begining of past 6 month then
=...
Size: 1,493 bytes
Customize:
|
Top contributing authorsRelated threads on "BOB: BusinessObjects Board":Related threads on other sites: |
||||||||||||
Thread profile page for "Always take 6 months history to calculate forcast" on http://www.forumtopics.com.
This report page is a snippet summary view from a single thread "Always take 6 months history to calculate forcast", located on the Message Board at http://www.forumtopics.com.
This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity
Home |
About Us |
Submit Your Site |
Update Your Site |
Get Search For Your Site |
Partners |
Contact |
Search Plugin |
Blog |
 |
Last Searches | Top Searches |
Designated brands and trademarks are property of their respective owners.
Use of this website constitutes acceptance of BoardReader's User Agreement and Privacy Policy.