SUM exactly same value as the field
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.