Sum up multiple ‘calculated fields’
-
Please how can I sum up about 5 calculated fields.
I have tried this code but I am not sure I got it right.
(function(){ var a = fieldname70.split('-'), b = fieldname71.split('-'), c = fieldname48.split('-'), d = fieldname68.split('-'), e = fieldname69.split('-'),('-'); return CONCATENATE(SUM(a[0].trim(),b[0].trim(), c[0].trim(), d[0].trim(), e[0].trim()),'-',SUM(a[1].trim(),b[1].trim(), c[0].trim(), d[0].trim(), e[0].trim())); })()I want to sum up the first five fields in the 6th one ‘One Time Investment Cost’
Thanks for your usual support.
The page I need help with: [log in to see the link]
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
The topic ‘Sum up multiple ‘calculated fields’’ is closed to new replies.