Datatable - Sum multiple row/column based on the fixed header

Hello, I am looking for the solution as explained in the Datatable image.

  1. No of Rows and Columns are all dynamic
  2. I want to achieve a summation for each Entity that will be described in the First Column always.

I hope my problem statement is clear if not please let me know

Hi @shubham.nagar

Have a look to the below thread :-

Might this will give you some starter help

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

2 Likes

@shubham.nagar
welcome to the forum

find some starter help here:
GroupBy_1Col_Sum_dynamicSumCols.xaml (12.1 KB)

it sums up all columns that are not used for identifying the groups (key col - like yor Company Col). It is dynamicly and if a new column will be present it is also catched for summing up

Let us know your feedback

2 Likes

Hey There, This runs ok - just one problem if any of the fields are blank it throws an error.

Scenario
(Kept Column 2 - First value as null)
image

Error

Coversion from String "" to type integer is not valid

Hi @shubham.nagar

Can you Try using NOTHING keyword der

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

Dear Pratik, this is just an example - In runtime it will be all the values will be dynamic with 100 columns and 200 rows.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.