Is there a way to change the number format in a report based off of the value of another field in the report? Specifically, I have a report where two of the fields are [units] and [quantity]. I am wanting the [quantity] field format to have no decimal places if the [unit] is "pounds". In all other cases ([unit] does not equal "pounds") I want the [quantity] field number format to have 2 decimal places. I have looked at conditional formatting, but that appears to only work for changing colors. Thanks for any help!