12 Replies Latest reply: Apr 8, 2011 11:58 AM by Sandro Pividori RSS

    Field as percentage of another field

    Gerhard Laubscher

      Hi,

      I would like to know how to create a pie chart showing one field as a percentage of another field.

      I have a field called 'OTB' (which is available credit) and another field called 'Credit Limit' - I would like to know what percentage of the total credit limit for all customers (so Sum[credit limit]) is available to them.

      So if the sum of all the customers' CL is 10 million, and the sum of all their Available OTB is 3 million, then I want a pie chart showing the 10 million, with 30% of it representing OTB.