YTD Runningsum() Issue

balachandarbe · Forum Member Joined: 15 Sep 2008 Posts: 6

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

MichaelWelter · 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]

soni_ak · 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??

balachandarbe · Forum Member Joined: 15 Sep 2008 Posts: 6

I am using only one data provider for Current and Last week for both.

Thanks for your reply.

balachandarbe · Forum Member Joined: 15 Sep 2008 Posts: 6

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

soni_ak · 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.

MichaelWelter · Posted: Wed Sep 17, 2008 8:57 am Post subject: Re: YTD Runningsum() Issue

balachandarbe · Forum Member Joined: 15 Sep 2008 Posts: 6

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

soni_ak · 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.