Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hey Hi,
You can use Set Analysis and ByPass the Filter,
For that you may use the following Code:
Count ({<FOReason=,FOCreason={'WHUP'}>}[Order Number])
Hope this helps...
Regards