I’m dividing a currency by a currency in an inline formula to show a percentage change. The result appears as a currency. I can’t figure out how to reformat this to a percent. I’ve tried the format function but can only add a % but not remove the $.
Here is the formula I’m working with (StartPrice$ - EndPrice$)/(StartPrice$) which always returns a decimal $0.00.