Skip to Content
0
Former Member
May 21, 2010 at 07:31 AM

BEX formula.. How to know the row value in formulas dynamically

38 Views

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