How to divide (any math operation) a regular number by number in a currency format?
I have one column written in a currency format. Lets call this column A.
Another column written in a regular number format B.
When I try to create a column formula in Column C like: Column A/ Column B, I get an error called invalid operation.
As you can see in the screenshot below, that formula I have in the Test column errors into "invalid operation".
The "Terms in Months of Contract" column, I tried converting that into both a currency and decimals, but since its a formula column, it looks like it won't let me.
Any ideas to get around this?
Screenshot for help:
Help Article Resources
Check out the Formula Handbook template!