Using the Let logical function

As a trainer I am commonly asked what does the Let function do?…The Let function is something that you'll run into if you're looking around in…databases that have been created by someone else, or even starter solutions or…in other training materials.…And the answer really is that it doesn't do anything. The Let function is a…unique function that actually doesn't add any additional programming features…to your calculations.…But rather creates an environment within the calculation, or the calculation…dialog window, where you can declare variables and those variables can be used…elsewhere within the calculation itself.…

Now what's the purpose of something like that?…Well, if we look at Let function, we can see that all the Let function is …is that inside the brackets you see there, you will declare these variables and…then you just run a calculation formula.…So whatever calculation formula you write in the second parameter…calculation, it'll run that.…But the nice thing about it is, if you look at this example here, I can say I'm…