5 Replies Latest reply on Jan 17, 2012 10:40 AM by philmodjunk

    Reporting percentages of subtotals and totals on a report

    med

      Title

      Reporting percentages of subtotals and totals on a report

      Post

      I designed a report to list only the summaries of the number of orders sold and the number of orders returned and their percentages for each geographic location. The report also shows the grand totals.

      for the percentage I created a calculation field =   if(totalorderssold=0;0;totalordersreturned/totaalorderssold/100)

      where totalorderssold and totalorders returned are summary fields.

      when I look at the report I see that the totals and subtotals are correct BUT the percentage column is carrying the same value in all lines which is the percentage of grand totals 

      I am not able to have the report display the percentage of EACH subsummary

      I also tried to put a different field in the subsummary band showing 

      getsummary(totalordersreturned;location)/getsummary(totalorderssold;location) but that is not displaying anything

      What am I doing wrong?