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!