I have a requirement where I have to get the values from previous calculation if the numbers are not present. For example for week 3 & week 4 I need to derive the values from Week 2. So, I am using above() to get to my answer and when I use the above() function the below table1 becomes like that in table 2 as shown
I want to have Week 4 also as 2000. So, can anyone help me to get that or is there a better way to do this?
please take look at attached script file. Its not an exact answer on your question but perhaps it helps.
I would say the reason why above "doesn't work" in week 4 is because sum(Amount) in week3 = 0. If you know that this happens only 2 times you could just use another "IF".
I have to admit that it looks not very nice and if possible I would do it in script.
If needed I can upload a sample qvw tomorrow.