So, the goal here is to filter the sharepoint list by date and then add the values in a column in the sharepoint list for the range of dates.
First, I created a label which connects to a date picker : -

I have created labels that go back 7 days from the date picker. I want to modify my above code to sum up the values for not only one date but all the 7 dates listed above. I tried putting a comma and add more labels but that just gives No Value.
Also, there are times when a certain date will not be present in the sharepoint List.

How do I go about doing this?