Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this data in model:
Date DateEnd Flag
01/06/2013 01/09/2013 0
02/09/2013 23/12/2013 1
Date mean DateBegin interval for value of flag.
Now I want calc how many days in selected period (year, month, days, week - anything) in calendar Flag was 1.
Example:
If user selected November: Day for flag is 30.
If selected September: day for flag is 29.
If selected Jule: day for flag is 0.
If selected 01/06/2013 - 23/12/2013: day for flag is 113.
It is possible to calculate in expression?
So you somewhere have a continuous Date field or calendar the user makes his selection in, right?
You can use INTERVALMATCH LOAD prefix in your script to link your flag periods to this date field (finally, I would probably join the flag to your calenda).
Then, doing your calculation is just summing the Flag value while user selects a Date field period.