title: Crystal Reports 10: Nested Formula
body: <p>I've a report which shows five different activity codes.  I'd like to sum all like codes and place a total for each of the 5 activity codes in a group footer.  I have it working for one activity code, but would like to write a formula which will look for all five and total each.  This is what I have:  </p>
  
  <p>(if {@activitycode_id}= "Not Ready" then {iActivityCodeStat.ActivityTime}else 0)</p>
  
  <p>What is the proper syntax to add additional ifs into one formula?  And then the best approach to totaling each one?</p>
  
  <p>Thank you!</p>