Get the transformation formula for a specified indicator — get_transform

get_transform_formula() gets the right transformation Excel formula for the specified indicator. Used in write_tranform_formula.

Usage

get_transform_formula(ind, raw_col, raw_rows, ind_ids, iso3)

ind: character with the indicator code (ind in billionaiRe::indicator_df())
raw_col: integer identifying the column where the raw value (pre-transformation) is located.
raw_rows: integer vector identifying rows indices where raw values for transformation are located. Must be the same length as ind
ind_ids: Named vector of indicator codes for input indicators to the Billion. Although separate indicator codes can be used than the standard, they must be supplied as a named vector where the names correspond to the output of billion_ind_codes().
iso3: Country ISO3 code.

character vector with the formula for the indicator, column, row combination specified. If indicator is not found, "" is returned.