### 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

This portion of the forum is intended for reporting possible bugs with the software. If you post questions of this type in the FM Pro Forum it be seen by more users than here.

I don't follow how

A 1

B 1

A+B 1

becomes

A 2

B 2

How did the 1's become 2's? What does A+B mean?

I'd guess that you want the total count of all records where a field has a SKU of A and a count of all Records that have a SKU of B in the same field. If so, a Summary report can be constructed such that you get this result, but I am making a lot of guesses at to what you want.