I am attempting to create a calculation that uses an exponential decay. In Excel, this is very easy since I can reference the cell that was calculated above the cell that is currently being calculated. Here is what it looks like in Excel.
Exponential Rate of Decay
=Current Balance * EXP(- Rate of Decay / 12)
I have tried the above() function but it will not calculate the values. I am guessing since there is a calculation inside of a calculation it is getting lost. Here is the calc:
above((Sum([Static Raw Value])/Sum([Static Number of Sites])/Sum([Static Number of Days In Month]))
Anyone have any ideas? Any help would be appreciated.