title: Crystal Reports Calculating a value from a summary total
body: <p>I have a summary total in my report and dependent on the value it needs to return a value in days.  My solution would require updates if summary of days exceeds the last value entered in the formula.  Is there a calculation that should be used here?</p>
  
  <p>Created an if then else formula in Crystal</p>
  
  <p>IF Sum ({GALAXY_WORK_ORDER_OPERATION_DAYS.Days}, {WORK_ORDER_FACT.WORK_ORDER_ID}) &lt;= 2 THEN 0.5 ELSE
  IF Sum ({GALAXY_WORK_ORDER_OPERATION_DAYS.Days}, {WORK_ORDER_FACT.WORK_ORDER_ID}) &lt;=  4 THEN 1.0 ELSE
  IF Sum ({GALAXY_WORK_ORDER_OPERATION_DAYS.Days}, {WORK_ORDER_FACT.WORK_ORDER_ID}) &lt;=  6 THEN 1.5 ELSE
  IF Sum ({GALAXY_WORK_ORDER_OPERATION_DAYS.Days}, {WORK_ORDER_FACT.WORK_ORDER_ID}) &lt;=  8 THEN 2.0 ELSE
  IF Sum ({GALAXY_WORK_ORDER_OPERATION_DAYS.Days}, {WORK_ORDER_FACT.WORK_ORDER_ID}) &lt;=  10 THEN 2.5 ELSE............</p>
  
  <p>This code requires many rows to be written and if the number increases the formula needs to change</p>