Demo Formula Entry

To create custom statistics, on a new row not containing any other demos, you write a formula involving one or more demos, using this method.

Formula

A formula consists of constants and/or tokens and mathematical operators.

A token indicates which statistic and demo should be used in the formula.  

The first character of a token is the statistics code (e.g., I = impressions, R=ratings, etc.).

The second character of the token is the Demo ID (the letter assigned to the demo on the Request Screen).

The mathematical operators are: * (multiply), / (divide), + (add), and - (subtract).

Example:  To divide the impressions for Demo A by the impressions for Demo B to yield a percentage composition value, you should key:  IA/IB*100.

Use Fractions Not Decimals in the formula

If you want to use a fraction in a calculated formula, you need to use a fraction, not a decimal, because the decimal point is an "invalid token" for a formula.

Example:  To increase viewership 10% over the value in a referenced cell, you would key it the formula as 110/100, not as 1.10

So, if the referenced statistic type/demo id is IA, then the 10% increase for that statistic would be

IA * 110/100

Notes: