1
00:00:03,940 --> 00:00:05,120
[Autogenerated] high in this lesson. I'm

2
00:00:05,120 --> 00:00:06,830
gonna show you how to add a calculated

3
00:00:06,830 --> 00:00:09,980
column to a SharePoint list, and I also

4
00:00:09,980 --> 00:00:12,340
want to add that this process is the same

5
00:00:12,340 --> 00:00:14,950
with the SharePoint Library. We're here in

6
00:00:14,950 --> 00:00:17,500
the sales team site, and we are on the

7
00:00:17,500 --> 00:00:21,060
sales by store list. It has a list of our

8
00:00:21,060 --> 00:00:24,420
items that we sell the cost of each item,

9
00:00:24,420 --> 00:00:28,040
the description and then these last few

10
00:00:28,040 --> 00:00:30,450
columns are all of our stores, and it

11
00:00:30,450 --> 00:00:34,100
shows the sales of each of these items buy

12
00:00:34,100 --> 00:00:36,640
store. What we're going to do is add a

13
00:00:36,640 --> 00:00:39,710
column that will add up the units sold per

14
00:00:39,710 --> 00:00:42,420
store and give us that total. So let's go

15
00:00:42,420 --> 00:00:44,210
ahead. Let's click on the ad column button

16
00:00:44,210 --> 00:00:46,810
over here to the right, and when we look

17
00:00:46,810 --> 00:00:49,540
down our list, we don't see one that says

18
00:00:49,540 --> 00:00:51,770
Calculated column. So we have to go down

19
00:00:51,770 --> 00:00:56,920
to the bottom and click more. First thing

20
00:00:56,920 --> 00:01:01,120
we need to do is select our column type.

21
00:01:01,120 --> 00:01:03,820
Look at the choices here. These are the

22
00:01:03,820 --> 00:01:06,590
choices for a single line of text. If we

23
00:01:06,590 --> 00:01:09,740
go ahead and click on calculated column,

24
00:01:09,740 --> 00:01:13,790
our page refreshes and well, that's a lot

25
00:01:13,790 --> 00:01:17,840
different isn't it? We're gonna go ahead

26
00:01:17,840 --> 00:01:19,820
and give our column and name, and it is

27
00:01:19,820 --> 00:01:26,380
simply going to be total units sold and

28
00:01:26,380 --> 00:01:27,980
we'll scroll down. We can add a

29
00:01:27,980 --> 00:01:29,840
description. I don't think we need to. I

30
00:01:29,840 --> 00:01:32,550
think the title is descriptive enough and

31
00:01:32,550 --> 00:01:34,840
we have to write our formula, and it's

32
00:01:34,840 --> 00:01:38,800
pretty basic. Start with an equal sign and

33
00:01:38,800 --> 00:01:41,240
we add our first column. You see, we have

34
00:01:41,240 --> 00:01:44,200
the list here, all of the different column

35
00:01:44,200 --> 00:01:50,230
headers. So ad, first column and a plus

36
00:01:50,230 --> 00:01:56,120
sign the second column and a plus sign the

37
00:01:56,120 --> 00:02:00,820
third column and a plus sign. You get the

38
00:02:00,820 --> 00:02:03,840
idea. I'm gonna pause here and I'll finish

39
00:02:03,840 --> 00:02:06,820
this out, not come right back. All right,

40
00:02:06,820 --> 00:02:09,290
I have finished the formula Have added in

41
00:02:09,290 --> 00:02:13,970
all of our columns here, Sore formula is

42
00:02:13,970 --> 00:02:16,170
done. Now let's go ahead. Let's scroll

43
00:02:16,170 --> 00:02:19,550
down a little bit more. How do we want

44
00:02:19,550 --> 00:02:22,230
this data? What type of data do we want to

45
00:02:22,230 --> 00:02:25,140
return? Well, it's just a simple number.

46
00:02:25,140 --> 00:02:27,180
Do we want to add decimal places? We're

47
00:02:27,180 --> 00:02:29,650
gonna leave it at automatic, but we have

48
00:02:29,650 --> 00:02:32,810
choices here for other decimal places and

49
00:02:32,810 --> 00:02:35,660
do we want it to show as a percentage and

50
00:02:35,660 --> 00:02:37,730
no, that's fine. We we don't need to do

51
00:02:37,730 --> 00:02:39,640
that for this column. We can go ahead and

52
00:02:39,640 --> 00:02:42,240
do it if we want, though, that's available

53
00:02:42,240 --> 00:02:47,820
to us. So let's click. Okay? And now we're

54
00:02:47,820 --> 00:02:52,290
back to our list. And when we come over,

55
00:02:52,290 --> 00:02:55,950
there is our calculated column showing us

56
00:02:55,950 --> 00:03:00,960
the total of units sold Pretty nice. Now

57
00:03:00,960 --> 00:03:02,770
we're gonna do one more. We're gonna go

58
00:03:02,770 --> 00:03:04,310
ahead and add another column that will

59
00:03:04,310 --> 00:03:06,170
give us the dollar amount of the total

60
00:03:06,170 --> 00:03:09,470
sales. So let's add that and again, we

61
00:03:09,470 --> 00:03:14,670
have to go down to more. We will choose.

62
00:03:14,670 --> 00:03:20,420
Calculated column. There we go. And this

63
00:03:20,420 --> 00:03:30,240
is gonna be sales total. And our formula

64
00:03:30,240 --> 00:03:33,190
is going to be total units sold times

65
00:03:33,190 --> 00:03:36,670
cost. So we have to start with an equal

66
00:03:36,670 --> 00:03:39,610
sign. DoubleClick to add our total units

67
00:03:39,610 --> 00:03:44,520
sold an asterisk. Total units sold times

68
00:03:44,520 --> 00:03:48,690
cost. And this one we want to show as

69
00:03:48,690 --> 00:03:53,320
currency automatic, the currency format.

70
00:03:53,320 --> 00:03:56,090
United States dollars. But we can add a

71
00:03:56,090 --> 00:03:58,000
whole bunch of other things if we wanted

72
00:03:58,000 --> 00:04:00,840
to, but we're fine with that. We're gonna

73
00:04:00,840 --> 00:04:07,220
click. Okay? And now we come back to our

74
00:04:07,220 --> 00:04:11,240
list and there is our sales totals now,

75
00:04:11,240 --> 00:04:14,940
which is just the units sold times, the

76
00:04:14,940 --> 00:04:18,700
cost and these air calculated columns. So

77
00:04:18,700 --> 00:04:23,470
if these values change, these totals will

78
00:04:23,470 --> 00:04:26,940
as well. So are total units sold. Here was

79
00:04:26,940 --> 00:04:32,270
1089 our sales total is 3021 45. So let's

80
00:04:32,270 --> 00:04:38,110
change. Let's go ahead. Let's select will

81
00:04:38,110 --> 00:04:41,540
select this first row click show actions a

82
00:04:41,540 --> 00:04:44,880
click on edit. We're gonna come down here

83
00:04:44,880 --> 00:04:48,430
and let's change the amount of 606 to 6.

84
00:04:48,430 --> 00:04:50,800
We're gonna change the amount of units

85
00:04:50,800 --> 00:04:54,710
sold to 125. Yes, grow back up and click

86
00:04:54,710 --> 00:04:59,590
Save and we see that it's changed there.

87
00:04:59,590 --> 00:05:06,850
So let's go. And we see now that that went

88
00:05:06,850 --> 00:05:09,020
ahead and updated for us. Remember, it was

89
00:05:09,020 --> 00:05:13,330
1000 and 89 before. Now it's 11 62 in our

90
00:05:13,330 --> 00:05:17,520
sales total is 35 44 10. So now you know

91
00:05:17,520 --> 00:05:20,010
how to add a calculated column to

92
00:05:20,010 --> 00:05:30,000
SharePoint list. Thanks for listening and I'll see you next time