Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

Custom form maths

Avatar

Level 4

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?

 

 

1 Accepted Solution

Avatar

Correct answer by
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.

 

View solution in original post

6 Replies

Avatar

Level 10

Hello,

 

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

 

Like this:

 

 

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

 

Avatar

Level 4

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

Avatar

Community Advisor

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.

Avatar

Correct answer by
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.

 

Avatar

Level 4

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