I have a formula field (Revenue) that is calculated from multiplying a Number field times a Currency field. The result is not showing as a Currency field.
Details:
Qty is a user-input field, data type is Number
Price is a user-input field, data type is Currency (USD)
Revenue is a formula field, (Qty * Price) -- it should be shown as a Currency type, but it's showing up as a decimal field.
How can I make Revenue show up as a currency data type in my views and reports???
Thanks.