Custom form maths | Community
Skip to main content
J
Jaxelle
New Participant
September 11, 2023
Solved

Custom form maths

  • September 11, 2023
  • 2 replies
  • 903 views

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?

 

 

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

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.

 

2 replies

F
FemkeCrAccepted solution
New Participant
September 11, 2023

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.

 

J
JaxelleAuthor
New Participant
September 11, 2023

Awesome - that did the trick! Thanks a lot. 

lgaertner
lgaertner
New Participant
September 11, 2023

Hello,

 

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

 

Like this:

 

 

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

 

J
JaxelleAuthor
New Participant
September 11, 2023

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

skyehansen
skyehansen
New Participant
September 11, 2023

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.

Terms & ConditionsAccessibility statement

Loading footer...