1 Reply Latest reply: Aug 1, 2011 5:16 AM by Rahul Gupta RSS

    Incorrect data when making selections

      We analyse failed shipments to customers by reason codes. When we make a selection on code WHMP this will give us details of what shipmenst were involved.

       

      We then have a  chart which includes the expression  'Count (Distinct If (FOCReason='WHMP', [Order Number], null()))'.  However the details also appear in another chart which includes the expression  'Count If (FOCreason='WHUP',[Order Number], null()))'.How do we stop this happening?