Using VBA to Analyze FinishVariance to generate a report

Question

I'm using Project Server 2010.
I have VBA code that generates a schedule analysis report. I'm adding a section that analyzes the FinishVariance of all non-summary tasks for instances where FinishVariance > 20 days and if found to be true it adds a line to the report with specific information about the task. The field definition for FinishVariance indicated it is stored as "minutes", which implies that dividing it by 1440 would convert it to days, although the math doesn't bear this out.

I've tried comparing the finishvariance value to both 10 and the result of the formula, but when I compare the results of the report to the actual FinishVariance field in the schedule, I'm seeing inconsistencies in the results, either with it including variances of < 20 days or not including all of the task with variances that are > 20 days.

I'm obviously missing something.

As usual, thanks in advance.
Dan

Answer 1

Office project is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_project
https://social.technet.microsoft.com/Forums/projectserver/en-US/home?category=project
https://social.msdn.microsoft.com/forums/office/en-us/home?category=officedev

--please don't forget to Accept as answer if the reply is helpful--