Calculated columns using previous values?

Vidit — Wed, 08 Jun 2016 15:07:09 GMT

Hi,

i have an input table like this.

i need to calculate the columns Offset and total. the logic for which are as follows

Total (calculated each quarter)	Value D of previous Qtr + value A of current \Qtr
Column Offset (for each category each quarter)
offset of A	Total- A for current Qtr
Offset of B	Total - B For Current Quarter
Offset of C	Total - B - C
Offset of D	Always 0

I need to create a dynamic logic for this, as data for more years may come.

They can be calculated in script or via expressions.

Please suggest. thanks in advance.

Regards

Vidit

Re: Calculated columns using previous values?

Anonymous — Thu, 09 Jun 2016 02:39:03 GMT

Hi Vidit,

Please check the attached qvw for an example of how to calcuate values in script.

Hope it helps.

-- Karla