Joined: 22 Sep 2011
Location: United States
Online Status: Offline
Posts: 2
Topic: Need to condense some formulas... Posted: 22 Sep 2011 at 4:49am
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
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged