My query is regarding filters. I want to pull out all the activities that begin in a particular month. Now if a particular activity is continuing onto next month, then that activity should be shown only till the end of the month for which the filter is generated.
Let me put up an example:
Let’s say an activity begins on June 25th and ends on July 4th. So the duration is 10 days. Now the filter applied must show the duration till June 30th (duration only 6 days). Further more the percentage of planned work must be also shown in the similar ratio. Like from June 25th to July 4th, the planned works is 100%, so till June 30th the planned work is 60% only. Only this should be shown.
So can such a filter be created?
Can the Forum members please guide me in this matter.
Cheers
Jatin