When attempting to create a formula field by taking $ values and determining % discount the formula is returning a $ value instead of a % value .
Bump, this would be nice to have a function to change the format of the value similar to how the number field allows you to pick the formatting.
Hi @Christopher_Tormey , welcome to the forum 
I appreciate your frustration, I also wish we could format the result of formula fields as you can with spreadsheets.
Until this is available, I would consider removing any currency formatting from your number fields such as ‘Total Before Discount’ and instead append a ($) at the end of the field’s title. e.g. ‘Total Before Discount ($)’, similarly as you have already done for your ‘IT Discount’ and ‘Sales Discount’ fields in which you have appended ‘%’ on the end of their field titles.
With this approach, users will be made aware of the field’s formatting within the field’s titles. Yes, not ideal but at least it removes any confusing results such as in your case where a percentage is displayed in currency.