High.
So let's start cleaning our decks from last to one of the most violin commonly used Ducs formula in
power B-A is using calculator function.
So what calculator really does is it evaluates an expression by modifying our expression based on certain
factors.
Suppose I have my product here.
It consists of so they have certain kinds of sales and there are these size to large medium or small
something like that.
So what my need here is Paul I want to see the sales of those products whose deal size is large.
So I can do that by creating a measure that would calculate function really does it a value.
It's our expression based on the certain filters of our need.
So Lekman them with large deal or something like that.
I use calculator here.
So I want to see some of my sales so I'll add some and put my sales call them up here
and now you can see after my did asking me whether certain kind of filters to my filter here will be
to add or does size equal to large.
So I use inverted commas because it is of type string.
Make sure that whenever you are playing these kind of filters.
Well if it is of type String do use inverted commas.
And if it is of a numeric you can directly put the numbers there.
So now this is my calculate column has been cleared and I simply press enter.
So now you can see your classic card is having large motorcycle's or having large planes or having one
large deal with this particular amount of cells.
So I'll just remove this one and add large bill.
There you go.
So classic cars motorcycles planes which we just showed you only those are senior with in the large
deal.
That's how calculator works.
So when you start working on you plan your own formulas you will find this is really very important
function because you can apply as many.
You can say it does appear to modify likes to modify your expression.
So in calculator you can use if the loop of IV and all those so functions in the calculator itself and
in the end you can apply filters as you need to study all this.
It was just a basic example up here.
If you have any kind of credits or there's any kind of doubt related to calculate just ask me the quiz
section.
I just showed you how to really easily you can use calculate formula.
So that's how it works.
So we'll continue in the next lecture and we will be seeing one of the most important functions in that
which is time intelligence done in our next lectures.
Thank you.