Here is a possible solution (provided that you are using ver. 8.5 or higher):
1. Load the number of days in your date range, or even pre-calculate the daily average:
Start & End as PeriodKey,
Start - End + 1 as Days,
Amount(Start - End + 1) as DailyAmount
2. Load a Calendar Date field, with all possible dates within your total date range.
3. Join the two tables using "INTERVAL MATCH".
4. Enable the date from the calendar for user selection.
5. Construct a "Set Analysis" formula that will only enable those dates that are selected and are within the range.
Your calculation of the amount would be:
sum(<Daily Amount> * Count (number of days that are selected and are within the period between Start and End)
Did you over come this issue? As you understand what exactly Oleg wants to do then I hope you can help me out here. Please look in to the below post and try to help me out. Thanks and in advance!
I've got a similar need than Jim G. and I'm trying to adapt your solution but I don't understand the 5th point:
"5. Construct a "Set Analysis" formula that will only enable those dates that are selected and are within the range."
I've got a list of persons with data historized like their adress for example and a calendar to enable user to choose a date. I want to display the correct adress of each person corresponding to the date selected.
The IF structure works in this case but I've got others data historized to display and then, calculation time increase a lot so I need to use intervalmatch.
So I don't understand how to construct a set analysis formula to enable only dates that are selected.
Thanks for advance,