Incorrect Progress Resource Assignments Tab
JoeFroMTB opened this issue · 4 comments
JoeFroMTB commented
The task progress from Project Online Enterprise Projects is multiplied by 100. The value is correct in the Project Tasks Table, but incorrect in the Resource Assignments Table.
sadanapriyanka commented
@JoeFroMTB can you help me understand what's the value for source column for the tasks with wrong progress data in Resource Assignments table.
JoeFroMTB commented
It was failing to convert to decimals for reporting % complete. Example
would be a item reported at 25% complete would be displayed at 2500%
…On Sun, Mar 21, 2021 at 6:30 AM sadanapriyanka ***@***.***> wrote:
@JoeFroMTB <https://github.com/JoeFroMTB> can you help me understand
what's the value for source column for the tasks with wrong progress data
in Resource Assignments table.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#15 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AS44BJKRXCQETIDEJNTKE7TTEXDFDANCNFSM4X26RI3A>
.
--
Joe Slonecki
sadanapriyanka commented
@JoeFroMTB can you try changing the data type to Decimal number for progress field?
Tonjemv commented
This was my solution for this problem, if it helps someone?
Progress = IF('Resource Assignments'[Source] = "Project Online", 'Resource Assignments'[Progress [old]]] / 100, 'Resource Assignments'[Progress [old]]])