How would I create a calculation based on the difference between different filters?

Need to create a calculation of batch ID of Q3G - Actuals if the same month.


This will give you the days in between.

You can use this to add some more logic.

I am not sure how the date difference will help here in the calculation

What are you trying to do then?

If it’s the same month you want to display certain values? Or what is the ideal outcome?

I want the dollar amount from planned batch ID for april to subtract the dollar amount of the actuals of april

would you need more information to assist?

Have you looked into lag function?

You would partition by month.

It might look something like this.