zero and blank values

Hi Team.   good day. im working on Goal Attainment per metric. and my goal is to calculate the percentage of each metric on how close they are to the Goals. im having troubles with this formula: Tr...