1
00:00:00,610 --> 00:00:06,620
In this video, we will learn about air handling, how we can perform error handling in power country.

2
00:00:06,700 --> 00:00:09,820
For this, we need to prepare one small data set.

3
00:00:10,750 --> 00:00:15,130
So we have to click here, enter data.

4
00:00:15,520 --> 00:00:24,020
The name of the column will be the first column product, product name, and the second is the quantity.

5
00:00:27,790 --> 00:00:32,380
And third one is the price or the unit price.

6
00:00:34,720 --> 00:00:40,180
And then the name of the product is like a product one.

7
00:00:48,760 --> 00:00:50,080
And product for.

8
00:00:52,690 --> 00:00:57,790
All right, so here is the quantity is like two or three or.

9
00:00:58,700 --> 00:01:02,280
And for this, we don't have anything.

10
00:01:02,780 --> 00:01:12,080
So can I get any and for the unit prices like it is the five to seven and.

11
00:01:13,880 --> 00:01:15,500
Eddie, like.

12
00:01:18,330 --> 00:01:23,820
So here you can then distribute a product.

13
00:01:26,950 --> 00:01:35,860
So this is the table a lot, so that is there so we know we can go to the power created by the task

14
00:01:35,890 --> 00:01:36,430
force later.

15
00:01:39,030 --> 00:01:42,510
And here, if we try to add new column here.

16
00:01:44,240 --> 00:01:44,890
Some call them.

17
00:01:47,400 --> 00:01:50,610
And it looks like total sales.

18
00:01:54,160 --> 00:01:59,290
Then we need to take quantity, multiply by unit price.

19
00:02:03,410 --> 00:02:14,750
That's it, so let's click, OK, so here you can see we are getting our message like we cannot apply

20
00:02:15,080 --> 00:02:15,620
error.

21
00:02:17,320 --> 00:02:24,850
Static to the tape deck, Senate prices find digital devices, OK, because digital type is number and

22
00:02:24,850 --> 00:02:31,110
we have a problem here in the quantity column due to any right.

23
00:02:32,050 --> 00:02:37,840
So one option is we need to convert this.

24
00:02:39,200 --> 00:02:42,700
Our text data, type two, number one, No.

25
00:02:45,200 --> 00:02:52,580
And let's delete this edit column, so let's try to add a custom column here.

26
00:02:55,830 --> 00:02:58,390
And at this time, we don't need to change any name.

27
00:02:58,410 --> 00:03:00,780
Let's try to see if it works or not.

28
00:03:01,350 --> 00:03:05,460
Quantity multiply by unit price.

29
00:03:08,160 --> 00:03:17,820
OK, and here you can see we are getting a search party for the first three product, but again, we

30
00:03:17,820 --> 00:03:26,040
are getting an error message here, right, that the data format error, we couldn't convert to numbers.

31
00:03:26,040 --> 00:03:34,050
So it is not possible to convert any DNA to, uh, to the numeric value.

32
00:03:35,100 --> 00:03:38,130
So what we can do is the first option is.

33
00:03:40,690 --> 00:03:48,460
We can remove this role and we can work on the contact and then we can remove this from.

34
00:03:49,480 --> 00:03:52,180
As you can remove, Adam.

35
00:03:54,220 --> 00:04:04,990
So the the road that contains an error message has been removed, but if we want to show the product

36
00:04:04,990 --> 00:04:12,190
for Barton with some suitable message or value, we just need to click here, removed error.

37
00:04:12,670 --> 00:04:18,980
So we have to use one function so that we can recalculate.

38
00:04:20,020 --> 00:04:22,600
So we have to add a new column here.

39
00:04:27,410 --> 00:04:31,550
And the name will be new, like a modified

40
00:04:34,940 --> 00:04:35,720
quantity.

41
00:04:39,080 --> 00:04:43,100
And here we have to use tri quantity.

42
00:04:44,490 --> 00:04:49,640
If it doesn't produce any error, then give me the quantity.

43
00:04:49,650 --> 00:04:53,870
Otherwise zero, that's it.

44
00:04:55,910 --> 00:05:04,820
So here you can see we are getting the new calamity, modify quantity and not let's try to put one more

45
00:05:04,880 --> 00:05:09,850
custom here and the name is Total Sales.

46
00:05:11,120 --> 00:05:17,150
And here we have to use modified quantity multiplied by unit price.

47
00:05:19,290 --> 00:05:27,700
I said, so here you can see we are getting ready for one thirty 135 to succeed and so on.

48
00:05:27,730 --> 00:05:31,110
So this is how we can do better and living in poverty.