Skip to main content
Solved

Create a sum of multiple numeric values extracted from the same text tfield

  • September 23, 2022
  • 2 replies
  • 63 views
M
Forum|alt.badge.img+3

Hi everyone,

first off, my skills are a bit basic, so I hope you have patience with me… I have a text field in which multiple numbers are being output by an automation and separated with a comma (it displays the file size of attachments.)

My goal is now to get the sum of all of these numbers in a formula field (I want to display the total filesize of all numbers combined).

I have tried using VALUE(Internal Notes) but in that case the numbers are just mashed together and not being calculated at all. So instead of “100200” I want this to display “300”.

Can anyone help me out on what to do? Or should this be resolved using scripts or something else? Any help would be much appreciated.

Best answer by ScottWorld

I would convert that field to a linked record field. Then you could create a Rollup field with the formula SUM(values) to get the total.

2 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • Answer
  • September 23, 2022

I would convert that field to a linked record field. Then you could create a Rollup field with the formula SUM(values) to get the total.

M
Forum|alt.badge.img+3
  • MarvinW
  • Author
  • New Participant
  • September 26, 2022

I would convert that field to a linked record field. Then you could create a Rollup field with the formula SUM(values) to get the total.


That worked perfectly, thanks for the tip!

ScottWorld
Terms & ConditionsAccessibility statement