Print Page | Close Window

Need to condense some formulas... Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Technical Questions Forum Discription: Formulas, charting data, Crystal syntax, etc. URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14451 Printed Date: 03 May 2024 at 11:10pm Topic: Need to condense some formulas... Posted By: thompa1717 Subject: Need to condense some formulas... Date 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 Any help/ advice would be appreciated

Print Page | Close Window