Summarize table with calculated progress percentage

Hi all!

Kind of stuck with the following. I have a table consisting out of 4 columns:

"Title of project", "Title of milestone","State","DueDate"

Example:

Project A|Introduction|Completed|11/30/2023
Project A|FollowUp|Active|01/31/2024

Project B|Introduction|Active|02/28/2024

I am trying to create a summarition table that would give me the following:

"Title of project","Time","Expected %","Actual %"

Which would result in:

Project A|2023|50%|50%

Project A|2024|100%|50%

Project B|2024|100%|0%

However, when I create a summarized table how do I get a calculation ont he expected table instead of the following:

Project A|2023|50%|50%

Project A|2023|50%|50%

Project B|2024|100%|0%

I used the following formula for this:

Thank you for your help!