2 Replies Latest reply on Sep 10, 2013 8:50 AM by Matt Lutton

    creating a calculated variable with different denominators

    Angela Webb

      Hello,

       

      I am trying to generate a percentage where I have different denominators.  I have a sum(count) already generated in my table crossed by categories and subcategories.

       

       

      My question is how can I calculate the percent of these sum counts when each category has a different denominator?  For example the sum of aspect_ratio is 540 while the sum of budget is 318.

       

      Please help!

      -Angela