cancel
Showing results for 
Search instead for 
Did you mean: 

How to achieve the following requirement in WEBI 4.0

ankit_vaidya26
Participant
0 Kudos

Hi Experts,

Please help me with following requirement :

MOnths|Carry Forward| Cumulative pending items|

APR | 0 | 3 |

MAY | 3 | 4 |

JUN | 4 | 5 |

JUL | 5 | 6 |

Above have 3 columns say Months, Carry Forward and Cumulative Pending items. Now in Carry forward Column I have to show the value of Cumulative Pending Items column previous value means In MAY month the value of Cumulative is being considered of APR month, similarly in JUN month of carry forward the value of cumulative of MAY should be considered.

Please help me to achieve te above requirement in Webi 4.0 SP6.


Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

former_member198519
Active Contributor
0 Kudos

Have you tried using:

[Carry forward]= if (isnull(previous([Cumulative Pending Items]) )) then 0 else Previous([Cumulative Pending Items])

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

I had same issue and was able to find the solution.

variables:

Opening Balance=Previous([backlog])

Backlog=RunningSum([INC Submit]-[Inc closed])

In your example replace:

INC submit =carry forward

Inc Closed = Cumulative pending items

ankit_vaidya26
Participant
0 Kudos

Hi Kuldeep,

I am trying to consider this carry forward variable in another variable .There is a column called total items where I am adding this variable with another... but while creating I am gettting error of reference i think because of PREVIOUS function is being used. Please let me know if there is any way out.

Thanks.

former_member198519
Active Contributor
0 Kudos

What is the formula you wrote? Have a look at the attached sample screenshot. Is this what you are trying to achieve

sample.jpg

ankit_vaidya26
Participant
0 Kudos

Hey Buddy,

Thanks a lot. It works. 🙂