How to compute the values inside the cell?

Question

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.

PARNPUL40081.25+166195.661236.43+5943.33603915.25+975.92+4191583.80229506.95+474141.53120554.46+17.88+278894.22182545.90+450.00+675425.0189815.96+178029.93229506.95+474141.5343986.60+3526.09+53794.7738970.44+85809.54603915.25+975.92+4191583.80252272.26+110.00+1126231.8843986.60+3526.09+53794.7758.47+129485.30+11.56+29598.47+72511.25229506.95+474141.53

atcodedog05 · Accepted Answer

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 Answer

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