Author |
Message |
balachandarbe Forum Member


Joined: 15 Sep 2008
           Posts: 6

|
Posted: Mon Sep 15, 2008 1:15 pm Post subject: YTD Runningsum() Issue |
|
|
Hi,
Can you help me for the below issues.
I am working on BO XI R2 and creating reports using Deski.
Currently I am displaying 2 weeks data with one measure object which will needs to calculate the projection value for the current and previous week data. I would like to calculate YTD for the projection(measures) for the current week, while applying the runningsum() function in the current week projection(measure), which is also get applying the previous week.
The wrong result which I am getting now,
Current week Previous week
Projection YTD
=Runningsum(Projection) Projection YTD
10 10 11 21
20 41 22 63
30 93 33 126
Expected result,
Current week Previous week
Projection YTD
=Runningsum(Projection) Projection YTD
10 10 11 11
20 30 22 33
30 60 33 66 |
|
Back to top |
|
 |
MichaelWelter Forum Advocate


Joined: 08 Aug 2002
                 
*6 Posts: 15020 Location: Rancho Cucamonga, CA, USA, Earth, Milky Way

|
Posted: Mon Sep 15, 2008 2:06 pm Post subject: Re: YTD Runningsum() Issue |
|
|
Welcome to B B!
[Moderator Note: Moving from General Discussion to BusinessObjects Desktop - MichaelWelter] _________________ Michael Welter, BOCP-BOE, Webi Image link
Ark Analytic Solutions
(909)899-3002
______________________
Follow me on Twitter Latest Blog Posts • 2019-02-22 Tableau Security Made Easy • 2018-09-20 Hello, Tableau • 2018-08-16 New Beginnings |
|
Back to top |
|
 |
soni_ak Principal Member


Joined: 15 Sep 2008
           Posts: 141 Location: Mumbai

|
Posted: Tue Sep 16, 2008 4:52 am Post subject: Re: YTD Runningsum() Issue |
|
|
Hi,
are u using two different data providers for Current and Last week or single DP for both?? |
|
Back to top |
|
 |
balachandarbe Forum Member


Joined: 15 Sep 2008
           Posts: 6

|
Posted: Tue Sep 16, 2008 11:33 am Post subject: Re: YTD Runningsum() Issue |
|
|
I am using only one data provider for Current and Last week for both.
Thanks for your reply. |
|
Back to top |
|
 |
balachandarbe Forum Member


Joined: 15 Sep 2008
           Posts: 6

|
Posted: Tue Sep 16, 2008 1:08 pm Post subject: Re: YTD Runningsum() Issue |
|
|
Hi,
As per the user requirement, we need to use single data provider to accomplish this report.
Please give me your feedback on this.
Thanks in advance.
Bala.K |
|
Back to top |
|
 |
soni_ak Principal Member


Joined: 15 Sep 2008
           Posts: 141 Location: Mumbai

|
Posted: Wed Sep 17, 2008 1:57 am Post subject: Re: YTD Runningsum() Issue |
|
|
Hi,
As per my understanding, you are using Crosstab to show Current and Last Week data and RunningSum is applied on a single Measure Object that is why it is adding last and current week data together.
If this is the case then u can try to solve this issue by Resetting the value for RunningSum to zero for each Week. It can be done by following synatx-
=RunningSum(<Projecttion>;<Week_Name>)
where <Week_Name> is the Object that displays 'Current Week' or 'Last Week' based on the date.
Try it out and give ur feedback whether it works or not. |
|
Back to top |
|
 |
MichaelWelter Forum Advocate


Joined: 08 Aug 2002
                 
*6 Posts: 15020 Location: Rancho Cucamonga, CA, USA, Earth, Milky Way

|
Posted: Wed Sep 17, 2008 8:57 am Post subject: Re: YTD Runningsum() Issue |
|
|
soni_ak wrote: | Try it out and give ur feedback whether it works or not. |
Please do not use Instant Message abbreviations on BOB. We want to keep BOB easy to understand for our International community. Thanks. _________________ Michael Welter, BOCP-BOE, Webi Image link
Ark Analytic Solutions
(909)899-3002
______________________
Follow me on Twitter Latest Blog Posts • 2019-02-22 Tableau Security Made Easy • 2018-09-20 Hello, Tableau • 2018-08-16 New Beginnings |
|
Back to top |
|
 |
balachandarbe Forum Member


Joined: 15 Sep 2008
           Posts: 6

|
Posted: Wed Sep 17, 2008 2:18 pm Post subject: Re: YTD Runningsum() Issue |
|
|
Hi,
Thanks for your prompt reply. You are correct, I am using the same methodology to implementing the runningsum() on a single measure object.
But as per your suggestion, I have used the same syntax as.
=RunningSum(<Projecttion>;<Week_Name>)
But I am getting multivalue error. The below formula which I have used for 21st week & 22nd week.
=Runningsum(<Projection>;21)
=Runningsum(<Projection>;22)
Please let me know if you find any solution on this.
Thanks & Regards
Bala.K |
|
Back to top |
|
 |
soni_ak Principal Member


Joined: 15 Sep 2008
           Posts: 141 Location: Mumbai

|
Posted: Thu Sep 18, 2008 1:04 am Post subject: Re: YTD Runningsum() Issue |
|
|
Hi,
Have you used Week_Object (for 21 and 22) in the report and apart from this, what other dimensions are u using.
for RunningSum, why are u using 2 different formulas
=Runningsum(<Projection>;21)
=Runningsum(<Projection>;22)
You need to create only 1 measure object having formula
=RunningSum(<Projecttion>;<Week_Object>)...It will reset sum based on value of Week_Object. |
|
Back to top |
|
 |
|