- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2019 07:15 AM
Hi Everyone,
I am attempting to calculate a 'Total Score' column with the sum of 10 integer fields. I have tried creating a business rule to calculate the value, however, the below code is not working.
Can someone take a look to see what I am missing? Any help would be greatly appreciated.
Thank you,
Brian
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2019 07:42 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2019 07:19 AM
try
var k = a + b + c + d + e + f + g + h + i + j;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2019 07:36 AM
Thanks, Mike! This worked. Now if I wanted to divide this value by the number of fields (10) to find the average to a decimal value, would it be something like this var k = (a + b + c + d + e + f + g + h + i + j)/10;? I think this solution alone would work, but would really like it to end in an average decimal value.
Thanks again!
Brian

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2019 07:42 AM
try
var k = ((a + b + c + d + e + f + g + h + i + j)/10).tofixed(2);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2019 09:06 AM
That worked! Thank you so much!