I am trying to create a dashboard based off 2 metrics. Some of the targets are whole numbers and some of the targets are percentages. Is there a way to set a cell to show a percentage, or a whole number...based off some criteria??
Never really encountered this...looking for some help please.

Thank you.