A user recently emailed us as follows:

In the User Entered Measure ‘Entry Setup’ screen ‘Entry Formulas” it does not seem possible to modify the mapping to

Allow use of a formula for example ACTUAL/D20.2= [Actual * 2]; but rather have to be left as is .

We think this is a point where people can become confused, so we'll shortly post our response as well...

Of course you can. You just have the syntax wrong. What is in square brackets is a virtual field name. Math operations would be outside the square brackets. So correct syntax would be:

ACTUAL/D20.2= ([Actual]* 2);

It doesn’t have to be called Actual…

ACTUAL/D20.2= ([Damaged Units]* 2);

You can have multiple collected fields

ACTUAL/D20.2= ([Damaged Units]* [Multi Factor]);

If you repeat collected fields they are only collected once.

{note: for actual line} ACTUAL/D20.2= ([Damaged Units]* [Multi Factor]);    
{note: for forecast line} FORECAST/D20.2= ([Damaged Units]* [Forecast Factor]);

What would be collected above, would be Damaged Units, Multi Factor and Forecast Factor.

And you can use formulas and FOCUS functions

ACTUAL/D20.2= IF ([Damaged Units] LT 0) THEN 0 ELSE [Damaged Units];