AnsweredAssumed Answered

Percentage of Total in Subsummary

Question asked by arosales on Nov 8, 2018
Latest reply on Nov 15, 2018 by user19752

Hello,

 

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.

 

ScreenCapture.JPG

Outcomes