From the course: SharePoint for Enterprise: Data Management

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Calculating columns

Calculating columns - SharePoint Tutorial

From the course: SharePoint for Enterprise: Data Management

Start my 1-month free trial

Calculating columns

“

- [Instructor] Let's talk about calculated columns, okay? . Calculated columns are really nice because it means that you can take information. Like in this case, I've got units and cost per unit and discount. And I come up with an invoice amount which is a calculation from those other numbers. The formulas that you use here are very, very similar to the formulas that you use in Excel. So not only can you do basic mathematical calculations but you can do some fairly complicated logical work as well. Let's take a little bit of a deeper dive into the total invoice amount there and see how we achieve that. So I'm going to go back into my list settings and I'm going to go into the invoice amount column and it says that it's calculated. And here's the calculation here. Actually, I cheated a little bit here. I've got a column that you didn't see in the view that calculates the gross invoice amount which is the quantity ordered…

Contents