#ERR error in Cumulative calculation

building reports desktopintelligence
1

Hi,

I need a cumulative sum on a Column which is basically a count of an object and this object is defined as a dimension in Universe. When I use RunningSum(Count()) I get #ERR error.

Attached is the screenshot of the report with error and highlighting the Function. Kindly suggest how this can be done.

Regards

Deepa
cumulative.doc (258.0 KB)

ssdipa (BOB member since 2008-11-03)

2

Deepa,

Looks like you only want the running sum of the Circuit ID column. So, I would suggest you use the formula RunningSum(Circuit ID). That should give you what you are looking for.

Mitra

Mitra Moini (BOB member since 2002-09-01)

3

Hi Moini,

I actually need Count of Circuit ID and not Circuit ID. I updated the attachment with correct Headers.

Please suggest.

Regards
Deepa

ssdipa (BOB member since 2008-11-03)

4

Hi Deepa,

It looks to be a problem with contexts as there is nothing wrong in your formula.

Try something Like

Cummulative = RunningSum(Count(<106005 00 Ic Circuit Identifier>) In Body) In

-Satish

forgotUN (BOB member since 2006-12-13)

5

Thanks Satish. Yes the way I used the RunningSum function is correct but when I further analyzed , this Error happens only when I sort on the Count of Circuit ID field.

Basically I need to first sort on the Count of Circuit ID column and them perform a RunningSum on it.

Please suggest.

Best Regards
Deepa

ssdipa (BOB member since 2008-11-03)

6

Hi Deepa,

Yes, you are right.
When ever we try sort, runningsum is giving error.

What is your basic requirment ? is it to calculate the cummulative percentages ?

forgotUN (BOB member since 2006-12-13)

7

The requirement is to sort Count of Circuit ID field , so that top numbers are seen first and then perform cummulative sum on a column to right. And finally have a cummulative percentage in the 4th column.

  1. Supplier Code; 2. Count of Circuit ID; 3.Cummulative Sum of (count of circuitID); 4.Cummulative Percentage(cummulative sum/total sum)

Any help will be very useful!

regards
Deepa

ssdipa (BOB member since 2008-11-03)

8

Hi :slight_smile:

I too tried the same way, even i am getting the same error. But i have an alternative way to achieve the same…

Create a Measure object in universe.

CountCircuitID=
Count(106005 Ic Circuit Identifier Object)

and keep the projection in object properties as ‘SUM’.
In report level use this and apply descending order and then create running sum variable

Cumulative Value=runningsum(CountCircuitID)

Hope this helps. Cheers!!

Prashu :india: (BOB member since 2005-08-17)

9

Hello Deepa,

I have implemented Pareto charts in Deski successfully which uses same procedure as you did. Calculating the Count then percentage then cumulative.
Initailly, DO NOT APPLY SORT. Calculate your percentage and cumulative place it in the table.

What i have observed is, Deski won’t show Errs when you
1/Create the table with you requried fields like Name, Count, Percentage, cumulative percentage.
2/ Then Apply sort on Count
Now, Deski won’t show any error when you sort. This may be work around for you.
I have attached a document which might be useful.

-Satish
Cummulative.doc (35.0 KB)

forgotUN (BOB member since 2006-12-13)

10

Hi Deepa,

Did you resolve the issue ?

-Satish

forgotUN (BOB member since 2006-12-13)