Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Please help me to get the total, i need the distinct count of order which was done as per ware house level.
I applied this formula but not getting the answer.
Sum(Aggr(Count(distinct{<[Sale Order Status New]={'DONE'},Facility_Updated>}),[Display Order Code]))
Sale Order Status New= If the order has been processed so from this i need only done data.
Facility Updated= Warehouse data
Display Order Code= Order Numbers
So i need the order count of Done as per warehouse means if 1 order has been went for 3 warehouse then the count will be 3.
Earlier i applied the formula for getting only Distinct count of display order code for sale order status new= done
Count(distinct{<[Sale Order Status New]={'DONE'}>} [Display Order Code])
And i am getting the proper answer.
Please help me to get the Display order Code Count if Sale Order Status New]={'DONE'} and if the order has been split as per warehouse.
Need this soon please help me to get the answer
Hi, you can try with:
Sum(Aggr(Count(distinct{<[Sale Order Status New]={'DONE'}>}),[Display Order Code],Facility_Updated))
Or:
Count(distinct{<[Sale Order Status New]={'DONE'}>} [Display Order Code]&'_'& Facility_Updated)