In this video, we will learn about air handling, how we can perform error handling in power country.
For this, we need to prepare one small data set.
So we have to click here, enter data.
The name of the column will be the first column product, product name, and the second is the quantity.
And third one is the price or the unit price.
And then the name of the product is like a product one.
And product for.
All right, so here is the quantity is like two or three or.
And for this, we don't have anything.
So can I get any and for the unit prices like it is the five to seven and.
Eddie, like.
So here you can then distribute a product.
So this is the table a lot, so that is there so we know we can go to the power created by the task
force later.
And here, if we try to add new column here.
Some call them.
And it looks like total sales.
Then we need to take quantity, multiply by unit price.
That's it, so let's click, OK, so here you can see we are getting our message like we cannot apply
error.
Static to the tape deck, Senate prices find digital devices, OK, because digital type is number and
we have a problem here in the quantity column due to any right.
So one option is we need to convert this.
Our text data, type two, number one, No.
And let's delete this edit column, so let's try to add a custom column here.
And at this time, we don't need to change any name.
Let's try to see if it works or not.
Quantity multiply by unit price.
OK, and here you can see we are getting a search party for the first three product, but again, we
are getting an error message here, right, that the data format error, we couldn't convert to numbers.
So it is not possible to convert any DNA to, uh, to the numeric value.
So what we can do is the first option is.
We can remove this role and we can work on the contact and then we can remove this from.
As you can remove, Adam.
So the the road that contains an error message has been removed, but if we want to show the product
for Barton with some suitable message or value, we just need to click here, removed error.
So we have to use one function so that we can recalculate.
So we have to add a new column here.
And the name will be new, like a modified
quantity.
And here we have to use tri quantity.
If it doesn't produce any error, then give me the quantity.
Otherwise zero, that's it.
So here you can see we are getting the new calamity, modify quantity and not let's try to put one more
custom here and the name is Total Sales.
And here we have to use modified quantity multiplied by unit price.
I said, so here you can see we are getting ready for one thirty 135 to succeed and so on.
So this is how we can do better and living in poverty.