Count Formula

[KC3]

Hi All,

I am stuck to get the data correct.

I am trying to take my Split order count.

1. Against 1 order id how many warehouse has been allocated. (image1)

 In the below image you can see that in one id it's shows 6 and for another's it's shows 0.

 Formula applied-

(Sum(Aggr(Count(DISTINCT [Facility_Updated]),[Sale Order Status New],[Display Order Code])))

2. After making pint 1 need the count if order num 159257 has been split under 6 warehouse then count needs to come under 6. (image2)

Please help me to make this data.

PFA images

[Mark_Little]

Hi 

Can't say for sure, buy my first guess would be the AGGR, You are aggerating by a field on in the table. Sale Order Status New what are values in this field? also i assuming Display Order Code is order code?

Once the you get the correct the Set Analysis for the first part the second could be a done with an IF statement.

[KC3]

HI,

Sales order status new is my status of order status if the order has been done or pending, yes Display Order Code is order code

Can you please help me to close this asap.

Needs to finish this Project today