Display the sum of only the visible input values

[bri.bubble01]

Currently, the total value of sales for each day is displayed horizontally using input, and the total value is displayed at the end(below picture).
If “date/time picker’ s value > input each day” input value is not visble (9/17> 9/18～).
And total value is display all each day inputs.(input 1 + input 2 +・・・・)

I want to control the total value,
if date/time picker’s value is 9/17, total value’value is total input 1～input 17(only visible value’s total).
How Can I set ?

[hanan1]

are inputs all filled at the point the user changes the date? or are they disabled?

[bri.bubble01]

Thank your reply.

When Date/Time picker’s value is changed,
inputs value is filled. but if “date/time picker’ s value > input each day” input value is not visble.

[hanan1]

If the list of dates is a RG of sales, then make the RG data source filtered by date (which I assume you already have set up, if irrelevant dates are hidden on date selection) and make the total field = RG sales, list of sales, each item’s value SUM.

If you actually have individual input fields and are hiding them using conditionals I don’t see how this can be done without a condition for each date, which unpractical.