Complex Formula - How to access other cells' data in a formula

[Former Member]

Hello,

I'm trying to create a formula to classify some registers to A,B or C depending in a total value percentaje.

A = de 0 a 80

B = 80,01 a 90

C = 90,01 a 100

Example:

Name Value % %Sum Class

A 2000000 38% 38% A

B 1500000 28% 66% A

C 1000000 19% 85% B

D 800000 15% 100% C

Sum 5300000 100%

In web intelligence I can get to,

Name = (Name)

Value($) = (Value)

%s/total =Percentage((Value))

%Sum ?

Class ?

The way to calculate the %Acum is first to sort all the registers by rank and then you can calculate A, AB, ABC, ABCD (this can be done in Excel), but I don't know how you can access other cells' values from a single cell.

If I can do that, then I can do an if() formula that filter %Sum by a range (if(%Sum>90;"C";if(%Sum<80;"B";"C")). My problem is how can I calculate the column %Acum

Thanks & Regards

SU

Edited by: soauniverse on May 24, 2011 10:42 PM

[Former Member · Accepted solution]

Use RunningSum([Object]) function to get the cumulative sum.

Regards,

Rohit

[Former Member]

"but I don't know how you can access other cells' values from a single cell"

example:

A 1

B 2

C 3

you want to add third column which is sum of itself and its predecessors(cummultive): previous() is the function in webi

A 1 1([query1].[obj1]+previous())

B 2 3([query1].[obj1]previous()Previous())

C 3 7([query1].[obj1]previous()Previous()+Previous())