Getting error of column not found. I want to calculate total sales per month and overall sales

Help Studio
, ,
1

image
image1918×838 86.3 KB

Please provide the zip file is possible and any help would be appreciated. I am new to UiPath, so not able to grasp things quickly

2

Hi @22bec066

If possible can you please share sample input excel and expected output

Regards,

3

image
image739×228 4.89 KB

Expected output should be a a pop up message showing the total sales of each month and the overall sales. PFA, the input dataset, thankyou.

4

@22bec066

Can you try this

The image depicts a UiPath workflow that reads data from an Excel file to calculate the total January sales and displays the result, 600, in a message box. (Captioned by AI)
The image depicts a UiPath workflow that reads data from an Excel file to calculate the total January sales and displays the result, 600, in a message box. (Captioned by AI)900×456 23.8 KB

totalsales_Jan = dt.AsEnumerable().Sum(Function(x) CDbl(x("Jan"))).ToString()

totalsales_Feb = dt.AsEnumerable().Sum(Function(x) CDbl(x("Feb"))).ToString()

totalsales_Mar = dt.AsEnumerable().Sum(Function(x) CDbl(x("Mar"))).ToString()

Regards,

1 Like
5

@22bec066

The image shows a workflow diagram of a data processing sequence that reads from an Excel workbook, calculates total sales for January, February, and March, sums them to determine overall sales, and displays the result in a message box with the value "2100". (Captioned by AI)
The image shows a workflow diagram of a data processing sequence that reads from an Excel workbook, calculates total sales for January, February, and March, sums them to determine overall sales, and displays the result in a message box with the value "2100". (Captioned by AI)942×752 43.8 KB

overallsales = (CDbl(totalsales_Jan)+CDbl(totalsales_Feb)+CDbl(totalsales_Mar)).ToString

Regards,

1 Like
6

I’ll try it right away and let you know. Thankyou for the swift and quick response. Really appreciated

1 Like
7

Still facing the same error of Column : Jan not found.

image
image634×688 25.6 KB

8

@22bec066

No need to give the range..Just give Excel.Sheet(“Sheet1”)

This image shows a programmed workflow activity in an automation tool for reading and processing data from an Excel spreadsheet named "SalesData.xlsx," extracting visible rows from a specified range and calculating the total from January's sales data. (Captioned by AI)
This image shows a programmed workflow activity in an automation tool for reading and processing data from an Excel spreadsheet named "SalesData.xlsx," extracting visible rows from a specified range and calculating the total from January's sales data. (Captioned by AI)702×761 58.1 KB

Regards,

1 Like
9

Done, removed that and that error has resolved, but now it shows this

image
image1363×436 35.2 KB

10

@22bec066

Can you show your workflow

11

image
image661×676 30 KB

12

image
image627×679 34.7 KB

13

@22bec066

No need to use For Each Excel Row activity..You can directly use Read Rang Workbook activity and Assign activities..

Please try this

Your final workflow should like below

This image depicts a workflow diagram in a software application, which reads sales data from an Excel worksheet, calculates monthly totals, sums these totals for a combined overall sales total, and outputs it via a message box. (Captioned by AI)
This image depicts a workflow diagram in a software application, which reads sales data from an Excel worksheet, calculates monthly totals, sums these totals for a combined overall sales total, and outputs it via a message box. (Captioned by AI)1480×707 35.5 KB

Regards,

14

Assign: Value cannot be null. (Parameter ‘source’) , i copied your whole flow. Still getting this error. Does the dt. — part need to be changed ?

15

@22bec066

dt is the Output of Read Range Workbook activity

The image shows a software automation workflow for reading an Excel worksheet named "Sheet1", calculating total sales for January, February, and March using data stored in a DataTable, and then displaying the overall sales in a message box. (Captioned by AI)
The image shows a software automation workflow for reading an Excel worksheet named "Sheet1", calculating total sales for January, February, and March using data stored in a DataTable, and then displaying the overall sales in a message box. (Captioned by AI)1353×743 58.7 KB

Regards,

1 Like
16

This has been resolved. But the error of Jan does not belong to the table is coming up again. Assign: Column ‘Jan’ does not belong to table DataTable.

17

@22bec066

Check if there is any space before or after column name i.e Jan and check sheetname

1 Like
18

I checked, everything is perfect.

19

@22bec066

Can you please share your xaml file

1 Like
20

Can you please share your number or email as here it says new users can’t upload files. So sorry for the inconvenience being caused