Skip to Content

How to achieve the following requirement in WEBI 4.0

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 18, 2016 at 02:29 PM

    Have you tried using:

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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2016 at 06:12 PM

    Hey Buddy,

    Thanks a lot. It works. :)

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2016 at 09:12 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 27, 2016 at 12:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded