How to achieve the following requirement in WEBI 4.0

[ankit_vaidya26]

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.

[former_member198519 · Accepted solution]

Have you tried using:

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