Formula statements

The get-statement has the following form:

{get: formula; expr: ; arg1: ; arg2: ; argN: ;}

The expression can handle basic mathematical functions. There should be at least 2 arguments and an operator to create a valid expression. The expressions will be validated from left to right. You can wrap expressions in parenthesis to ensure these are executed first.

The supported operators are:

absolute

{get: formula; expr: (arg1 times arg2 divide arg3) absolute; arg1: {get: data; varcode: bevtot; geoselect: compare}; arg2: {get: data; varcode: bevtot}; arg3: -10}

Calculate the absolute value of a negative value of the indicator "bevtot".

divide

{get: formula; expr: arg1 divide arg2; arg1: {get: data; varcode: bevtot; geoselect: base; periodlevel: year;}; arg2: {get: data; varcode: bevtot; geoselect: compare; periodlevel: year; periodoffset: 1};}

Divide the value of the second-to-last available year of the indicator "bevtot" from the value of the last available year of "bevtot" to calculate the difference.

min

{get: formula; expr: arg1 min arg2; arg1: {get: data; varcode: bevtot; geoselect: base; periodlevel: year;}; arg2: {get: data; varcode: bevtot; geoselect: compare; periodlevel: year; periodoffset: 1};}

Subtract the value of the second-to-last available year of the indicator "bevtot" from the value of the last available year of "bevtot" to calculate the difference.

plus

{get: formula; expr: arg1 plus arg2; arg1: {get: data; varcode: bevtot; geoselect: base; periodlevel: year;}; arg2: {get: data; varcode: bevtot; geoselect: compare; periodlevel: year; periodoffset: 1};}

Add the value of the second-to-last available year of the indicator "bevtot" from the value of the last available year of "bevtot" to calculate the difference.

times

{get: formula; expr: arg1 times arg2; arg1: {get: data; varcode: bevtot; geoselect: base; periodlevel: year;}; arg2: {get: data; varcode: bevtot; geoselect: compare; periodlevel: year; periodoffset: 1};}

Multiply the value of the second-to-last available year of the indicator "bevtot" from the value of the last available year of "bevtot" to calculate the difference.