Hi,
I have a scenario where I have to check for the data based on the Date field from now.
I have Product Number 1 has Date as July, So I have to check from Today's date to July's data(VOL1 to VOL3).
And if data isn't entered, then I have to highlight the null from VOL1 to VOL3 for the null values like wise for every Product Number.
So Totla count for
Product 1 is 0(VOL1 to VOL3).i.e From May 2022 to July 2022,
Product 2 is 8(VOL1 to VOL4).i.e From May 2022 to August 2022
I was able to achieve using IF condition, Rather I would prefer to FOR loop due to script performance.
Note: VOL1 to VOL6 will be dynamic as for now, VOL1 is May and in next month VOL1 will be June.
For Reference |
Will be dynamic(From the Current Month) -> |
May-22 |
Jun-22 |
Jul-22 |
Aug-22 |
Sep-22 |
Oct-22 |
Product Number |
Date |
VOL1 |
VOL2 |
VOL3 |
VOL4 |
VOL5 |
VOL6 |
1 |
7/1/2022 |
- |
- |
- |
1 |
3 |
1 |
2 |
8/1/2022 |
3 |
5 |
- |
- |
2 |
5 |
Output be like :