Make total with summary or calculation, file in attachment

[W4hyu213]

Test15::Qty for same ItemNumber example:

ItemNumber : 536-880 has Qty: 60 ( has 3 record)

ItemNumber : 556-884-01 has Qty 26 (has 3 record)

 

How to get Total Qty for both ItemNumber is 86 (60+26 this is in RED when short by POFes), not (60*3)+(26*3) = 180+78 = 258

The total Qty for all ItemNumber should be 378 not 1103

 

Test15.fmp12

[Steve Martino]

You have no data in the fields.

[W4hyu213]

Sorry here i re-upload the file

 

Test15.fmp12

Edited March 10, 2020 by W4hyu213
Need words