Calculate total amount

Help
, ,
1

I want to calculate the total amount. so how can I use it?

image
image751×479 18.6 KB

2

Scraped the datat and pass the scraped to Datatable variable and use this

dataTable.AsEnumerable().Sum(Function(row) row.Field(Of Decimal)(“Amount”))

@Aarti_Godhasara

cheers :smiley:

Happy learning :smiley:

3

@Aarti_Godhasara,

If you are extracted the data from that table, then you can calculate the total amount using the below line of code.

yourTable.Compute("Sum(Amount)", String.Empty)
4

it is not structure data.

5

I wan to get a total of amount but it is not structure data

image

6

As others have pointed out: This looks like pretty structured data and you should be able to extract it with the Data Scraping wizard. Please don’t open duplicate topics like this.

Cheers

7

Data scrapping is not supporting in this

8

Why not?

Do you have the option to export this table somehow?