Display the sum of only the visible input values

bri.bubble01 · 2024-09-17T02:07:42.782Z

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 ?

あ1280×720 106 KB

hanan1 · 2024-09-17T05:31:40.171Z

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

bri.bubble01 · 2024-09-17T05:49:33.302Z

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 · 2024-09-18T10:28:41.048Z

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.

system · 2024-11-26T02:07:47.635Z

This topic was automatically closed after 70 days. New replies are no longer allowed.