Solution ID: prim80739
Calculated Column producing ‘Error’ or the wrong value.
Status: Reviewed
Version(s): 8.2, 8.5, 8.6

Problem: Calculated Column producing ‘Error’ or the wrong value.
Problem: When importing from P6, calculated columns which use other column values (e.g. COL10) are producing ‘Error’ or the wrong calculated value.
Problem: A calculated column contains the value ‘Error’.
Cause:

This happens when the column being referenced (e.g. COL10) is itself referencing a Task User Field (e.g. P70 Start) and is due to there being too many Task User Fields.
Fix: Workaround:

Reference the Task User Field directly instead of the column.  This simplifies the number of references.


Example: Where (COL13-COL10) is the sum of  (Start – P70 Start), The Task User Field Would be used instead of the column making it: (COL13 – @USERFIELD(“P70 Start”))
Fix: This known problem in Primavera Risk Analysis (Pertmaster) is currently under review and may be corrected in a future release.