Skip to main content

How do I see which production codes have had a changed final forecast today?

Create a custom formula column that shows the change in the final forecast with the period "day". Then you see where changes have happened today.

Create a custom formula column in Prod. Codes that shows the change in the final forecast, with the period "day". Then you can see right away where changes have happened today.

How to do it

  1. Go to Prod. Codes.

  2. Click Columns at the top right, select Custom columns and click + Add. Set Type to Formula.

  3. Select the variable for final forecast (expected final cost) in the Formula field. Click Period, select Day and click Confirm, so that the column shows the change today.

  4. Give the column a name you recognize, for example "Change in final forecast today", and click Save.

  5. Sort on the column to get the production codes with changes at the top.

The Columns panel in Prod. Codes in AIMZ with a new custom column of the type Formula. 1 points to the Add button for a new custom column, 2 to the Formula field, and 3 to the Day option in the Period drop-down list.

Good to know

  • The column is especially useful when many users work in the same project and the project manager wants to see what has changed.

  • You can use the same formula with a different period, for example week or month, if you want to see changes over a longer time.

  • Save the column in a shared table profile if several people are going to use it.

Related questions

Did this answer your question?