Crystal Reports 10: Nested Formula
- by Heather
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:  
(if {@activitycode_id}= "Not Ready" then {iActivityCodeStat.ActivityTime}else 0)
What is the proper syntax to add additional ifs into one formula?  And then the best approach to totaling each one?
Thank you!