AnsweredAssumed Answered

How to calculate sum of a field with same value

Question asked by duhongfei626@gmail.com on Aug 3, 2012
Latest reply on Aug 6, 2012 by philmodjunk

Summary

How to calculate sum of a field with same value

Product

FileMaker Pro

Version

12

Operating system version

Win7

Description of the issue

Hi
The problem to be solved is like this, I have a table with:
Table: Input
SKU       Quantity
A                 1
B                 1
A+B               1
Table: Output
A outcome table is to calculate all quantity with A or B like:
SKU       Quantity
A                 2
B                 2

Is there a simple function that can be written for Table Output's Quantity= ????
Thanks

Steps to reproduce the problem

Set a table
SKU       Quantity
A           1
B           1
A+B         1

Expected result

another table resulting in:

SKU       Quantity
A           2
B           2

Actual result

I tried a lot of ways but it only results in:

SKU       Quantity
A           1
B           1

Outcomes