Custom form maths

[Jaxelle]

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?

[lgaertner]

Hello,

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

Like this:

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

[Jaxelle]

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

[skyehansen]

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

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/calculated-custom-data/cal...

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.

[Femke_Crijns · Accepted solution]

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.

[Jaxelle]

Awesome - that did the trick! Thanks a lot. 

[Jaxelle]

I've now added a 'Divided' by option - is there any reason why this wouldn't go through accurately?

It should be Business Value score + Time Criticality / Technical integration type 

(40 + 0 / 2) = 20 

but it's pulled through as 0? 

Screenshots attached.

Thanks as always