User Profile
Williamwil88
Frequent Visitor
Joined 9 years ago
User Widgets
Contributions
Re: Formula Error
The Issue Date slicer corresponds to the table data. This may be part of the issue. The date field in the zMerps table corresponding to the shipping quantity is SH_ShipDate. The data table visual only reflects information from the NCMR query accept for the _QPPM measurement which pulls shipment quantity from the zMerps query. Below, I've provided a snapshot of my values and filters sidebar for the NCMR table. NCMR Query Fields zMerpsFormula Error
I am attempting to calculate a value called _QPPM using two different sources. The value is derived from the number of identified failure divided by the number of shipments for the month multiplied by one million. The two sources are unrelated. I have set up a simple table. I have added a measure to my query source to capture the value. The failures are captured in one source ‘NCMR’[Initial Qty Reject], and shipping quantity is captured in another source ‘zMerps_Will_ShipInfo’[SHL_ShipQty]. When I attempt to parse the information by month the calculation is incorrect. The sum of all shipments for the year is used in the calculation rather than the sum of shipments by month. Any assistance the community can provide is appreciated. _QPPM = (SUM(NCMR[Initial Qty Reject]) / SUM('zMERPS_Will_ShipInfo'[SHL_ShipQty])) * 1000000
