Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to create a set analysis that will only show a line if the sum of the orders on any date for a customer are less than or equal to 15 cases or less than or equal to 650 dollars.
This is what I originally had but now looking at it again it does not seem to be the correct logic. I think what this is doing is checking the customer for that date range, if the sum of its cases are less than or equal to 50 or less than or equal to 650 dollars. I need it to look at each day separately.
sum({$<[Customer Adj]={"=(sum({$<$(vSO_Closed_Only),[Transaction Date]={'>=$(=date(vxToday-35))'}>} [Cases_Aggr])<=15 or sum({$<$(vSO_Closed_Only),[Transaction Date]={'>=$(=date(vxToday-35))'}>} [Sales_Aggr])<=650)"} >}
[Cases_Aggr])
How do I change it so it compares the orders by day instead of within the range I put?
Yeah the conditions need to be:
[Originating cl for order]-={'B', 'E', 'P'}
AND
vSO_Closed_Only
AND
<2000 over the last 7 days
AND
<=15 cases OR <=650 dollars On a single day
[for Customer Adj]
So, for each day, you want to look back 7 days? I suggest you to look into The As-Of Table for this as this can drastically slow down your calculation. But if you want to do it directly into your expression... you will need to use Missing Manual - Above() and Below() to get this done...
Hi Sunny,
Can you let me know where does we use double dollar sign ??
Regards Manu