Complex Formula - How to access other cells' data in a formula
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
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)
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
Edited by: soauniverse on May 24, 2011 10:42 PM
Use RunningSum([Object]) function to get the cumulative sum.