MPCS SUMMARY
————————————————————++++++++++-
EMERALD: COUNT = [abase sql= ‘SELECT COUNT(DISTINCT(EMERALD)) AS Total FROM ALLMPCS’], / TOTAL = N[abase sql = ‘SELECT SUM(EMERALD) FROM ALLMPCS’] ONLY
NMPCS: COUNT = [abase sql= ‘SELECT COUNT(DISTINCT(NMPCS)) AS Total FROM ALLMPCS’], / TOTAL = N[abase sql = ‘SELECT SUM(NMPCS) FROM ALLMPCS’] ONLY
SSAMPCS: COUNT = [abase sql= ‘SELECT COUNT(DISTINCT(SSAMPCS)) AS Total FROM ALLMPCS’], / TOTAL = N[abase sql = ‘SELECT SUM(SSAMPCS) FROM ALLMPCS’] ONLY
TOTAL ALLMPCS= N[abase sql = ‘SELECT SUM(EMERALD+NMPCS+SSAMPCS) FROM ALLMPCS’] ONLY