RAG Conversion formula

hi All,

Hoping someone can help me out...

-Column A is a Forecast RAG Traffic Light column

-Column B is a formula that converts these RAG to a numeric value eg (R = 0 , A = 0.5 , G = 1)

-Column C is a $Day Rate

-Column D is a $Total Rate

My issue is when I create a formula in Column D of =ColumnB*ColumnC I am presented with the #INVALID OPERATION error

Any suggestions how to get around this?

Find more posts tagged with

Formulas

Accepted answers

All comments

Kelly Moore

Hey @Kegan Copas

If possible, please post your current formula. Is column C also a formula? If yes, is it possible to post that? Also, is it possible to get a screenshot of your data?

My suspicion is you have data in your formula that is behaving as text rather than values. The above requests will help the community troubleshoot those questions.

Kelly

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.