1 Reply Latest reply on Mar 9, 2010 1:19 PM by philmodjunk

    Calculate a Sum based on a value list

    alexandros

      Title

      Calculate a Sum based on a value list

      Post

      Hello everybody

      This must be a pretty basic question for some here.

      I have a very simple database with a few fields. What I would like to do is find a way to calculate the sum of a number field based on a value list.

      To be more specific I have a value list with A,B and C an amount filed and a sum field. 

      I would like to have 3 fields with the sum of the amount field for every of the three members of the value list.

       

      Thank you in advance for any help.

      Alexandros