Thanks a lot Megan, great approach
How did you display the “%” at the end in group B?
The formula returns an integer on my side and if I add it at the end of the formula (adding &“%”) I cannot make a sum in the mirror column.
I had to complexify a few the formula due to multiple criteria to be considered but using the same formula as your gives me the same behavior.
IF(FORMAT_DATE({Roll-On / Roll-Off#Start},“YYYY-MM-DD”)<=FORMAT_DATE(TODAY(),“YYYY-MM-DD”),IF({Status}=“Booked”,{% Allocation},0)+IF({Status}=“To be booked”,{% Allocation},0)+IF({Status}=“Booking requested”,{% Allocation},0),0)*100