Need help on expression

[#1]

Hi

How to calculate the number of days, each store has been stocked out continuously

Ex. store-A had stock on 1-jun and 3-Jun and there were no stock on 2-Jun, 4-Jun and 5-Jun.

Now I need to show like as of 5-Jun, the particular store has been continuously stocked out for 2 days.

[#2]

Hello.

I am attaching an example that I think can solve your problem.

I modified the script to make that calculation to load the Excel file.

Now you tell me if it's solution.