1 Reply Latest reply on Jul 23, 2012 4:25 AM by comment

    Calculating a fraction in a subsummary

    bdubeshter

      I have a report that gives a sub-total of product x sold in each state, as well as the sub-total for each county in the state. I want to calculate the fraction of product x sold for each county according to its sales in each state. I tried setting up a calculated field using the getsummary fx but am getting the wrong answers. I'm a beginner at this, so any guidance would be appreciated.