I need to chart the cost per full time employee. A running total is used for the cost while a formula is used for the full time employee. The full time employee formula uses both a running total and fomulas. How can I make the cost per employee FTE available to chart?
FTE formula:
({#13 GF2 YTD Act Total Expenses}/{@05 GF2 YTD Act Total Employee FTE})
Total Employee FTE:
(({#05 GF2 YTD Act Total Hours Employee}) /
(({@Cur Year 2080 conv for Leap Year}/{@Cur Year 365 conv for Leap Year})*
{@Days in Month YTD}))
Thank You!
FTE formula:
({#13 GF2 YTD Act Total Expenses}/{@05 GF2 YTD Act Total Employee FTE})
Total Employee FTE:
(({#05 GF2 YTD Act Total Hours Employee}) /
(({@Cur Year 2080 conv for Leap Year}/{@Cur Year 365 conv for Leap Year})*
{@Days in Month YTD}))
Thank You!