1. 

   astroshark, Member

   Hello,
   I am needing help with using the dbr.calc utilizing the dbr.hdr command, below is some example code.

   
   
   select 'dbr.hdr', '[n]';
   
   select 'dbr.crosstab', '[dt]';
   
   select 'dbr.calc', '[total_pct]','[data_column]/[total_column.sum]*100';
   
   select 'dbr.hidecolumn', '[data_column]', '[total_column]';
   
   select agent_name as 'Agent Name[n]',
   
          client_status as 'Client Status[st],
   
          date as 'Date[dt]',
   
          null as 'Total %[total_pct]',
   
          data_column as '[data_column],
   
          total_column as '[total_column]'
   
   group by 1,2,3;
   
   

   If I have more than one name then it shows subtotals and the total. What I am trying to do is to perform the dbr.calc command based on the vertical sum for each individual name. So if I have multiple names on this report then it calculates the formula based on all the names as a whole instead of each individual person which is what my goal is. I may be talking in circles so please let me know if you need further clarification.
2. 

   astroshark, Member

   Nvmd after some more searching within the forum I found my answer

   https://mydbr.com/forums/topic.php?id=2045

Reply

You must log in to post.