Data Transformation Engine Design Studio Tutorial

Chapter 11 - Partitioning Types to Simplify Map Rules Deliver Map Source File
Design Studio Tutorial
223
♦ Use the
COUNT function to count the following records:
#CustomerPOs
=COUNT ( Customer<>PO<>Record:Collection )
#CustomerForecasts
=COUNT ( Customer<>Forecast<>Record:Collection
)
#DistributorPOs
=COUNT ( Distributor<>PO<>Record:
Collection )
#DistributorForecasts
=COUNT (
Distributor<>Forecast<>Record:Collection )
#SupplierInvoice
=COUNT ( Invoice<>Record:Collection )
For the %CustomerPOs and %DistributorPOs data objects, enter map rules to
calculate the percentages of Customer and Distributor records in the entire
input file.
Use the multiply (*) operator to multiply the data object by 100. For example:
100 * #CustomerPOs Field:Report
multiplies the #CustomerPOs Field component of Report by 100.
Use the divide operator (
/). For example:
=100 * #DistributorPOs Field:Report / COUNT (
PO<>Record:Collection )
divides the count of the PO records by (100 times the number of
#DistributorPOs Field in Report).
%CustomerPOs
=100 * #CustomerPOs Field:Report / COUNT (
PO<>Record:Collection )
%DistributorPOs
=100 * #DistributorPOs Field:Report / COUNT (
PO<>Record:Collection )