Show only if the Sum of orders for a particular date is <=15

[djbloiss]

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?

[djbloiss]

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]

[sunny_talwar]

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...

[manu1512]

Hi Sunny,

Can you let me know where does we use double dollar sign ??

Regards Manu