6 Replies Latest reply: Mar 19, 2014 4:11 PM by Herbert Chitate RSS

    Calculated Field

      Hi All,

       

      I have a table with fields Customer ID, Order Amount, Delivered Amount. How can I say Ordered Amount - Delivered Amount and only return in a straight chart amounts that are greater than zero i.e. only the customer ID's with outstanding orders. I also need the calculated field showing i.e telling me how much is outstanding.

       

      Thank you

       

      Herbiec09