Calculating columns

- [Instructor] Let's talk some more about…calculated columns, okay?…Calculated columns are nice…because they do the work for you.…As I mentioned earlier in this course, the formulas…you use here are very similar to those in excel.…So, not only can you do basic mathematical calculations,…you can do some pretty complicated logical work as well.…Let's start by taking a deeper dive…into the Total Invoice Amount column.…I'm going to go into my list settings…and I'm going to scroll down to Total Invoice Amount.…

I'm going to click in here, you can see this is a…calculated field based on other columns.…So lets click down.…Now, look here.…Here is the calculation that is involved here.…I actually cheated a little bit,…I've got another column that you didn't see in the view…that calculates the Gross Invoice Amount,…The quantity ordered multiplied by the unit price.…Now, I could have done that calculation here,…but I thought it might be useful to have that as a value.…

And it did save me a little work in this column.…My calculation here takes the number from the Gross column,…