How to divide (any math operation) a regular number by number in a currency format?

Hi,

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:

Find more posts tagged with

Formulas

Accepted answers

All comments

mbsamuel6

I said any math operation, but it only gives me the error for divide and multiply

mbsamuel6

I figured it out. You'll have to use the value function.

=value(column a/ column b)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.