Skip to Content
0
Former Member
Oct 25, 2012 at 01:29 PM

Is it possible to Create a "for" loop using WEBI formulas and Variables? In BO 4.0 SP02

1310 Views

Hi All 😊

I'm using BO 4.0 SP02. I'm using a Crosstab. and BICS connection.

I would like to use a "for" loop to achieve my requirement of Calculating sum of Revenue for All the years below Selected Year. (Note: I cant use RunningSum.)

For Ex: 2006 will consists of (2004+2005+2006 Revenue). If User Selects 2005 Then, (2004+2005 Revenue).

Actually This is Runtime Calculation and There is no value stored in ECC table. I have to Refer Two Rows of Same Column and Add them to get Revenue.

i tried it, but i'm getting Aggregated value(Sum) of All Years and Crosstab shows Same value for all years.

For Ex: Revenue of 2006 is $ 1,230,000. And Revenue of 2005 is $ 1,000,000. And Revenue of 2004 is $ 750,000.

But it is showing $ 1,230,000 for all the three years.

I cant select Previous years like i=2004;i<2006;i--.

Kindly provide your Suggestions.

Thanks in Advance.

-Parthiban

Transaltus