I'm trying to create a report to summarize advising time by advisor/coach then description. I'm using sub summaries and don't have a body in the layout. The calculations work until I trry to add a calculation for percentage of total time. The domain time and count are both summary fields. I tried creating the following calculation (s_DomainTime / s_DomainCount) but it didn't work. I also tried creating another summary field for fraction of total but the s_DomainTime field is greyed out and not available.
Also, when using summaries is a summary field and summaryGrandTotal needed for to summarize data in the summary layout and footer or can I just drag same field to the different areas? I created the two fields because I modeled after a youtube tutorial but I'm not sure if that's correct.
Also, is it possible to alternate row color in a subsummary part of layout? I'd like the color to change on the change of description.
I'm a beginner user. Please advise. Thank you in advance.