Reply To: Fix Starting Point for Calculation

[Mathew]

Hi Thomas,

The value of 100 is not needed.

Var3 = Var1 - Var2; Var4 = (0.9 * Var3[1]) + (0.1 * Var3);

1 2 3 4

Var3 = Var1 - Var2; Var4 = (0.9 * Var3[1]) + (0.1 * Var3);

Optuma will sort out the first value. You can use BarIndex to do an IF() and do a special case when it is 0, but it should not be necessary.

Hope that helps.
Mathew

1 user thanked author for this post.

Thomas