How to compute the values inside the cell?

[RichardAlt]

Hi all,

How can I compute the values inside the cell?

I have this sample dataset.

I need to sum the values in the cell.

PAR	NP	UL
40081.25+166195.66	1236.43+5943.33	603915.25+975.92+4191583.80
229506.95+474141.53	120554.46+17.88+278894.22	182545.90+450.00+675425.01
89815.96+178029.93	229506.95+474141.53	43986.60+3526.09+53794.77
38970.44+85809.54	603915.25+975.92+4191583.80	252272.26+110.00+1126231.88
43986.60+3526.09+53794.77	58.47+129485.30+11.56+29598.47+72511.25	229506.95+474141.53

[atcodedog05 · Accepted solution]

Hi @RichardAlt 

Here is how you can do it.

1. Use record ID tool to set ID so that it can used for roll up

2. Use text to column on column PAR to split values into rows with separator +. This ways values are split to rows.

3. Use select tool to keep only ID and PAR. And change PAR data type to double.

4. Use summarize tool to groupby ID and sum of PAR. This ways values for each ID is summed up.

5. Similar way do the same for others.

6. Use join multiple to join them back together.

Hope this helps 🙂

[Ben_H · Accepted solution]

Hi @RichardAlt,

I did the same process as @atcodedog05 with a slight simplification.

If you transpose the data after the record ID you only need to use a single text to rows tool, then simply cross tab it back.

Regards,

Ben

[atcodedog05]

@Ben_H Manh!! why didnt i think of that 😅