Actual

Actual value for a metric for the given time period.

Plan

Plan value for a metric for the given time period. Note that there can be multiple plan values (e.g. Original Plan, Working Plan, Forecast) each of which can be defined as a separate scenario.

Act LY

Actual value for a metric in the same period Last Year.

Formula:

LAST({act})

Plan LY

Plan value for a metric in the same period Last Year.

Formula:

LAST({plan})

Act LLY

Actual value for a metric in the same period Last Last Year, i.e. 2 years ago.

Formula:

LAST(LAST({act}))

Plan LLY

Plan value for a metric in the same period Last Last Year, i.e. 2 years ago.

Formula:

LAST(LAST({plan}))

% var Act vs. Plan

Percentage variance between the Actual value and the Plan value

Formula:

{act} / {plan} - 1

% var Act vs. Act LY

Percentage variance between the Actual value and the Actual value from Last Year

Formula:

{act} / LAST({act}) - 1

% var Act vs. Act LLY

Percentage variance between the Actual value and the Actual value from Previous Year.

Formula:

{act} / LAST(LAST({act})) - 1

% var Plan vs. Act LY

Percentage variance between the Plan value and the Actual value from Last Year.

Formula:

{plan} / LAST({act}) - 1

% var Plan vs. Act LLY

Percentage variance between the Plan value and the Actual value from Previous Year.

Formula:

{plan} / LAST(LAST({act})) - 1

Var Act vs. Plan

Variance between the Actual value and the Plan value

Formula:

{act} - {plan} ({act} - {plan}) * 10000 // If percentage

Var Act vs. Act LY

Variance between the Actual value and the Actual value from Last Year

Formula:

{act} - LAST({act}) ({act} - LAST({act})) * 10000 // If percentage

Var Act vs. Act LLY

Variance between the Actual value and the Actual value from Previous Year

Formula:

{act} - LAST(LAST({act})) ({act} - LAST(LAST({act}))) * 10000 // If percentage

Var Plan vs. Act LY

Variance between the Plan value and the Actual value from Last Year.

Formula:

{plan} - LAST({act}) ({plan} - LAST({act})) * 10000 // If percentage

Var Plan vs. Act LLY

Variance between the Plan value and the Actual value from Previous Year.

Formula:

{plan} - LAST(LAST({act})) ({plan} - LAST(LAST({act}))) * 10000 // If percentage

Act Build

Build is a measure of how a metric has changed period after period. A use case is to see how sales have been growing week over week, or month over month. Actual Build shows how the Actual value has grown from the perevious period.

Formula:

{act} / PREVIOUS({act})

Plan Build

Plan Build shows how the Plan value has changed from the previous period.

Formula:

{plan} / PREVIOUS({plan})

Act LY Build

Formula:

LAST({act}) / PREVIOUS(LAST({act}))

Act LLY Build

Formula:

LAST(LAST({act})) / PREVIOUS(LAST(LAST({act})))

% of TTL Act

Actual value as a percentage of its parent. Example can be the percentage Footwear department makes as a percentage of the Womens division.

Formula:

{act} / PARENT({act})

% of TTL Plan

Plan value as a percentage of its parent.

Formula:

{plan} / PARENT({plan})

% of TTL Act LY

Actual value as a percentage of its parent from Last Year.

Formula:

LAST({act}) / PARENT(LAST({act}))

% of TTL Act LLY

Formula:

LAST(LAST({act})) / PARENT(LAST(LAST({act})))

% of Time TTL Act

Actual value as a percentage of the total value for a specific time period. Example use case is looking at what percentage a time period makes for the entire year.

Formula:

{act} / TIME_TOTAL({act})

% of Time TTL Plan

Plan value as a percentage of the total value for a specific time period.

Formula:

{plan} / TIME_TOTAL({plan})

% of Time TTL Act LY

Actualized value as a percentage of the full year from Last Year.

Formula:

LAST({act}) / TIME_TOTAL(LAST({act}))

% of Time TTL Act LLY

Actualized value as a percentage of the full year from 2 years ago.

Formula:

LAST(LAST({act})) / TIME_TOTAL(LAST(LAST({act})))

% of Grand TTL Act

Actual value as a percentage of the business. Example can be the percentage Footwear department makes as a percentage of the overall business.

Formula:

{act} / ROOT({act})

% of Grand TTL Plan

Plan value as a percentage of the business.

Formula:

{plan} / ROOT({plan})

% of Grand TTL Act LY

Actual value as a percentage of the business from Last Year.

Formula:

LAST({act}) / ROOT(LAST({act}))

% of Grand TTL Act LLY

Actual value as a percentage of the business from Last Last Year, i.e. 2 years ago.

Formula:

LAST(LAST({act})) / ROOT(Last(LAST({act})))
Did this answer your question?