Calculation of base index (return relative to a first value in array)

Hi everyone,

I would like to make the following functions (by selecting all ID's and Values for example) for columns Return and Base Return

ID Value Return Base Return
1 20 0 0
1 -20 -2 -2
1 -30 -0.50 -2.50
2 10 0 0
2 11 0.10 0.10
2 -2 -1.18 -1.20

return = (new value-original value) / abs(original value) FOR EACH ID

Base return = (new value-First value) / abs(First value) FOR EACH ID

First return or base return (per ID) should let's say be 0

Hi, the file attached
the first sheet containts the expected result in columns Return and Base return.
The function should be used to 1) mark all items in Column ID and column Value in order to produce expected
result in column Return (Return function), 2) mark all items in Column ID and column Value in order to produce expected result in column Base Return (Base Return function),

The second sheet contains example, at least how I tried it with the code in module 1, but it is not a function ...just tried...

Best regards

This is a duplicate post and as same is opened in CS subforum. This thread will now be closed, you may continue in your other thread.

Thread Closed.