|
The goal is to get the turnover % for a specific month of a year... so I have solved that by using 3 formulas... as shown below. Is there anyway to combine these formulas to reduce the amount of formula fields??
Jan Count = If ({DBHREMP.TERM_DATE} > Date (2011, 01, 31) or
{DBHREMP.DATE_HIRED} <= Date (2011, 01, 31))
and
{DBHREMP.TERM_DATE}= DateTime (2001,01,01) then 1 else 0
Jan Terms = If {DBHREMP.TERM_DATE} in Date (2011, 01, 01) to Date (2011, 01, 31) then 1 else 0
Jan Turnover %= (Sum ({@Jan Terms})/(Sum {@Jan Count}))*100
Any help/ advice would be appreciated
|