3 Replies Latest reply on Feb 26, 2013 2:05 AM by Andreas Linden

    How do I calculate a ratio of two different domains within a field?

    Andreas Linden

      Hi,

       

      I'm trying to graph the ratio between two domains within a field - for instance, I could have a table consisting of the fields 'date', 'product', and 'revenue'; the 'product' field data can either be 'Mac' or 'PC'. How would I go about setting up a calculated field to work out the ratio of these two product types?

       

      Many thanks

      Andy