Skip to Content
0

Sharing Variable Grouped by Days selected that month

Aug 22, 2017 at 03:41 PM

16

avatar image
Former Member

I'm attempting to find a way to have a formula or variable return the number of days selected in the primary report for a given month and then use that number in a subreport based on the month group it's in..OR just find a way to do it directly in the subreport To explain better:

Let's say I select in my date of service parameter July 1st - August 21st

That means I am selecting for 31 days in July and 21 days in August

Date of Service (DOS) is a group in both the primary report and the subreport

The issue here is that the subreport does not have a service on each day. Whereas in the main report every day will have at least 1 service. For instance, only 14 of the 21 days have a service in the subreport. Therefore I can't just do a count of DOS.

I'm trying to do a projection monthly census based on MTD numbers in the subreport. It groups as such:

Fiscal Year

Month

DOS

Let's say I've selected July 1st - August 21st as mentioned above.

In July I had 150 units. Therefore, my projected should remain as 150.

In August i already have 90 units. However, that's only for 21 days. My projected should be about 133. (Units * (31/21))

I can't figure out a way for it to do 31/31 for July, but only 31/21 for August. And remember, of those 21 days, only 14 had services.

Any thoughts?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers