Level 4

Solved

Custom form maths

6 replies
952 views
Translate All

Is there any reason why the math's from a custom form doesn't add up?

It should be as per the highlighted yellow: Business value score (100) PLUS Time Criticality Rating (20) = should give the total rating of 120 but it's pulling through as 20?

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

F

FemkeCrAccepted solution

Level 4

You could try using the SUM formula in your calculation:

SUM({DE:Business Value Score},{DE:Time Criticality Rating})

But, for this to work, your two custom fields should be number fields instead of text fields.

lgaertner

Level 9

Hello,

Did you try to convert your strings to a number before?

Like this:

NUMBER({DE:Business Value Score})+NUMBER({DE:Time Criticality Rating})

Translate

J

JaxelleAuthor

Level 4

That's doesn't work for me (screenshot attached). It says it's invalid expression

Translate

skyehansen

Syntax is important -- you would benefit from bookmarking this link.

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-data-expressions.html?lang=en

Additionally you can pick up the right syntax from just using the standard editor in the calculated field section to help you through this.

TLDR: "Number" should be in all caps.

Translate

F

FemkeCrAccepted solution

Level 4

You could try using the SUM formula in your calculation:

SUM({DE:Business Value Score},{DE:Time Criticality Rating})

But, for this to work, your two custom fields should be number fields instead of text fields.

Translate

J

JaxelleAuthor

Level 4

Awesome - that did the trick! Thanks a lot.

Translate

Sign up

Login with SSO

Login to the community

Login with SSO