Year to Date Balance Formula

[MrTBC]

Crystal 8.5, Progress Database

I have 12 fields containing the financial balances for 12 financial periods ({balance1}, {balance2}, etc.).
I need a formula to calculate the balance to date for a given financial period entered in a parameter field {?period}.
I can see how to do this with an ugly Select Case statement, but would rather use an If Then structure with a variable, but can't seem to make it work (think it requires 12 different If statements).

Thanks very much guys.

 

[dgillz]

Actually it would require 11 Ifs and one Else. This is about as good as its going to get.



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com