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 ?
are inputs all filled at the point the user changes the date? or are they disabled?
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.
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.
This topic was automatically closed after 70 days. New replies are no longer allowed.
