How to recreate in AVA the project progress % from Forecast

To recreate the progress figures you see in Forecast, you can use the following formula in Advanced Analytics:
 

CASE
WHEN max([Project Stage]) = (max([Project Stage]),[Project Stage1])
THEN 1
WHEN max([Workflow Status]) = (max([Workflow Status]),[Workflow Status1])
THEN 1
ELSE sum([Total Project Minutes Registered])/([Total Project Minutes Registered1]+[Total Project Remaining Minutes])
END

 
The fields in bold have to be filtered to the "Done" status. That way, all done projects and tasks will have 100% progress.

Format the final output value as a percentage.