Hi all,
I just need to clarify a doubt..
Requirement:
COL1 - COL2
-
Y1 - X
Y2 - X + 12
Y3 - X + 12 + 12
.
.
.
YN - X + 12 + 12 + u2026 12(n)
-
Y is dynamic from the source datau2026.. Itu2019s the year (2009,2008u2026 etc..)
X value is from the user (i/p variable value). Some dummy valueu2026
Now, the main logic I want to incorporate is like using a formula for COL2
COL2 Formula looks like thisu2026. X + (12 * N) where N= 0 for the 1st row; 1 for the 2nd row; 2 for the 3rd row like thatu2026..
How to dynamically allocate value for N based on the row count?
Pls. let me know if you find somethingu2026.
Thanks.
Edited by: Arun Bala G on May 21, 2010 10:59 AM