@gliddon in your last if statement IF statement add an additional green box where the blank is. This should allow the 100% bar to appear
IF({Calculation}<1.00,“ :green_square: ”,“ :green_square: ”)
Also, how did you get rid of the spacing between you...