I am new to the EKL stack. I am trying to calculate MTD sales from data set.
We have three columns
- Product Code
- Date (dd-MM-yyyy format)
All I am trying to do is calculate MTD sales for e.g. If today is 04th of Aug 2021. The code should be able to filter the records from 01st Aug 2021 to 04th Aug 2021 and sum the Sales column. The date which do not fall into the filter condition of MTD should not be considered for the MTD calculation.