Forum Discussion

mumair's avatar
mumair
Icon for Helper I rankHelper I
9 years ago

Help with not double counting

My data looks like the following:   Shipment | Voyage | Product | Failed Tanks | Count of Failed Tanks 1000 | NA100 | A | 3D, 3E | 2 1001 | NA100 | A | 3D, 3E | 2 1002 | NA100 | A | 3D, 3E | 2 ...
Need Help
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
9 years ago

=calculate(countrows(tablename),tablename[failed tanks]<>"N/A")