Expand my Community achievements bar.

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 7

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