Summing Calculations (Cumulative %)

Summing Calculations (Cumulative %)

Summary This article will demonstrate more of the scripts that can be used in calculation arithmetic. Here we will concentrate on how to sum up calculations, specifically, to give a cumulative vertical % calculation
Applies to Askia Analyse.
Written for Researchers, Developers, Data Processors.
Keywords Cumulative, Crossed calculation, Table arithmetic, Forloops, Coordinates, data, Calculation arithmetic, Percentage down, vertical %.

The .qes file and portfolio containing the examples discussed is attached: Table Arithmetic Examples 7.rar.

In Analyse, there is a pre-set calculation for Cumulative % on flat calculations i.e. table with only variable in rows (no columns). However, if we want to do this with columns involved (crossed calculations) then there is no pre-set option.

We can get around this by using table arithmetic to add a calculation which will sum up each pre-set vertical %.

I will now talk through the steps / syntax used to achieve the above table where we sum v% into a new calculation we have added, 'Cumulative %'.

First insert a calculation of type: Calculation arithmetic

Hit the script button and enter the syntax shown above (and contained in the example file).

The points of note here are as follows: 

If CurrentCell.Row.Index = 1 Then

Row.Index is a sequential number assigned to each response in each variable in the rows. When we are looking at the first response in the rows i.e. Row.Index = 1 then do the following:

  return Calc(3)
End if

Return the value for the third calculation (v%)

Then, for every next occurrence of this calculation, we add the current (row's value of) v%: Calc(3)

to the last (row's value of) Cumulative %: CurrentTable.GetCell(CurrentCell.X,CurrentCell.Y-4).Value

This is the row 4 rows above the current one, hence we use: CurrentCell.Y-4 

There is a detailed article about Row, Column & Edge Index keywords here.

Have more questions? Submit a request