Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Instead of having to create an expression, in a query or report, every time you want to do a calculation, you can now create a field right in your table that will perform calculations based on your data. Let's make one. I'll click on the Create tab and over here to Table. First, I'm going to put in our Company Name and I'm going to add a Currency field for the total that did owe us and I'll create another field for how much they've paid. Now, the last field I want is Amount Due.
So, what I'll do is go up to More Fields and come down here to Calculated Field and over to the right for Currency and my calculation is the Total Amount minus the Amount Paid and I'll name it Total Due. Now, when I fill this in, any amount that they owe us, note that because it's currency, it fills in dollar sign and the commas and the decimals automatically.
They've paid us $2000 and it instantly says that they owe us $8000. Please note however, that this does not work with date fields, because the data would be constantly changing at every moment. So you can see that the new Calculation data type will make life much easier with answers to your mathematical formulas available at all times.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74065 Viewers
80 Video lessons · 129503 Viewers
52 Video lessons · 63827 Viewers
59 Video lessons · 49598 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.