Aggregating a locked percentage value

So it seems that I have something that requires multiple steps to accomplish. I am trying to find the % of NOSHOWS from a table of instances and keep that number up on the dashboard. I am trying to d...