Expand my Community achievements bar.

Calculating Difference Between Planned and Actual Hours

Avatar

Level 3
Hi All- Would someone be able to share the text mode string that is needed to calculate the difference between planned hours and actual hours (planned minus actual)? I am trying to add an additional column that just shows the difference. Thanks Chris Levitsky Guidemark Health
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 7
Try this…this is one Project View I have. Column added: displayname=Hrs Remain textmode=true valueexpression=({workRequired}-{actualWorkRequired})/60 valueformat= (Of course, you can name the column whatever you want - for mine, it is "Hrs Remain". Terry Hynd EBSCO Information Services

Avatar

Level 3
That worked! Thanks so much. Chris Levitsky Guidemark