[Autogenerated] high in this lesson. I'm
gonna show you how to add a calculated
column to a SharePoint list, and I also
want to add that this process is the same
with the SharePoint Library. We're here in
the sales team site, and we are on the
sales by store list. It has a list of our
items that we sell the cost of each item,
the description and then these last few
columns are all of our stores, and it
shows the sales of each of these items buy
store. What we're going to do is add a
column that will add up the units sold per
store and give us that total. So let's go
ahead. Let's click on the ad column button
over here to the right, and when we look
down our list, we don't see one that says
Calculated column. So we have to go down
to the bottom and click more. First thing
we need to do is select our column type.
Look at the choices here. These are the
choices for a single line of text. If we
go ahead and click on calculated column,
our page refreshes and well, that's a lot
different isn't it? We're gonna go ahead
and give our column and name, and it is
simply going to be total units sold and
we'll scroll down. We can add a
description. I don't think we need to. I
think the title is descriptive enough and
we have to write our formula, and it's
pretty basic. Start with an equal sign and
we add our first column. You see, we have
the list here, all of the different column
headers. So ad, first column and a plus
sign the second column and a plus sign the
third column and a plus sign. You get the
idea. I'm gonna pause here and I'll finish
this out, not come right back. All right,
I have finished the formula Have added in
all of our columns here, Sore formula is
done. Now let's go ahead. Let's scroll
down a little bit more. How do we want
this data? What type of data do we want to
return? Well, it's just a simple number.
Do we want to add decimal places? We're
gonna leave it at automatic, but we have
choices here for other decimal places and
do we want it to show as a percentage and
no, that's fine. We we don't need to do
that for this column. We can go ahead and
do it if we want, though, that's available
to us. So let's click. Okay? And now we're
back to our list. And when we come over,
there is our calculated column showing us
the total of units sold Pretty nice. Now
we're gonna do one more. We're gonna go
ahead and add another column that will
give us the dollar amount of the total
sales. So let's add that and again, we
have to go down to more. We will choose.
Calculated column. There we go. And this
is gonna be sales total. And our formula
is going to be total units sold times
cost. So we have to start with an equal
sign. DoubleClick to add our total units
sold an asterisk. Total units sold times
cost. And this one we want to show as
currency automatic, the currency format.
United States dollars. But we can add a
whole bunch of other things if we wanted
to, but we're fine with that. We're gonna
click. Okay? And now we come back to our
list and there is our sales totals now,
which is just the units sold times, the
cost and these air calculated columns. So
if these values change, these totals will
as well. So are total units sold. Here was
1089 our sales total is 3021 45. So let's
change. Let's go ahead. Let's select will
select this first row click show actions a
click on edit. We're gonna come down here
and let's change the amount of 606 to 6.
We're gonna change the amount of units
sold to 125. Yes, grow back up and click
Save and we see that it's changed there.
So let's go. And we see now that that went
ahead and updated for us. Remember, it was
1000 and 89 before. Now it's 11 62 in our
sales total is 35 44 10. So now you know
how to add a calculated column to
SharePoint list. Thanks for listening and I'll see you next time