3 Replies Latest reply on Nov 21, 2018 1:46 PM by Paul Wachtler

    Calculated field referencing table calculation - seems like it should be so simple!

    Sean Morris

      Hi all. I've got a simple table showing two sets of counts and their respective percentage-of-totals. All I want to do is create one more column that divides one percent of total by another to create a ratio. I've tried creating a calculated field, using [% Total Grades] / [% Success Grades], but when I bring that into the table, it returns a '1' for each row. In practice, the ratio should be some decimal between about .7 and 1.1.

       

      Attached is a screen grab illustrating what I'm trying to do.

       

      tablecalc.PNG