I had figured this formula out before and was using it, but I had to restore my software and forgot to write it down. I had used a formula I found on here as a reference, but I can't locate that post anymore.
I am trying to calculate Compound Amount/Sum of all compound amounts, I can't remember if this required two custom calculations, but this is what my attempt looks like now:
I can't get the calc to clear the check, nothing I am using is closing the 'SUM' argument.
Any help is appreciated.