10 Replies Latest reply on Apr 14, 2011 9:50 PM by JamesWong

    SUM exactly same value as the field

    JamesWong

      Title

      SUM exactly same value as the field

      Post

      Hi forum!! Am trying to get the total sum of my 'Amount' column, instead of adding all the values from every row it seems FileMaker is only mirroring the 'Amount' value of each row. The formula am using is Sum(Expenses::Amount). I got it working when I used a summary field but it wouldn't let me relate it to other databases.

      Capture.PNG