For Loop Logic for Scenario

[rammuthiah]

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 :