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?
Solved! Go to Solution.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Hello,
Did you try to convert your strings to a number before?
Like this:
NUMBER({DE:Business Value Score})+NUMBER({DE:Time Criticality Rating})
Views
Replies
Total Likes
That's doesn't work for me (screenshot attached). It says it's invalid expression
Views
Replies
Total Likes
Syntax is important -- you would benefit from bookmarking this link.
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.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Awesome - that did the trick! Thanks a lot.
Views
Replies
Total Likes
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
Views
Replies
Total Likes