dbr.calc help

(2 posts) (1 voice)
  1. astroshark, Member

    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



You must log in to post.