I need just one day amount based on seelction at prompt.
I have amounts that spreads evenly across days.
Mon - 100
Tues - 100
Wed - 100 and so on
If user select any day at prompt. I just need one total of 100. But my amount gives 300 or more.
How do l restrict the amount to just 100 for one day. I have a time restrictive measure that pulls the total amount by days. I do not need everything just one amount every time l run report.
I am trying to use userresponse where prompt = Selected day but not getting it.
Thank you