on 10-18-2016 3:08 PM
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.
Have you tried using:
[Carry forward]= if (isnull(previous([Cumulative Pending Items]) )) then 0 else Previous([Cumulative Pending Items])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What is the formula you wrote? Have a look at the attached sample screenshot. Is this what you are trying to achieve
Hey Buddy,
Thanks a lot. It works. 🙂
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.