I am trying to create a conditional summation to show the total amount in dollars of shipped but not billed orders.
Basically I need to
Sum Table1.Estimate IF Table2.StationName is between "Shipped: Fedex" and "Shipped: UPS"
Additionally I need some help with the highlighting expert where I want to Highlight...
Color 1: Table.dateexpected IF Date is older than 1 week.
Color 2: Table.dateexpected IF Date is between 1 week and yesterday.
Color 2: Table dateexpected IF Date is between Tomorrow and Today etc.
With those 3 examples I think i can manipulate enough to get what I want done with various highlighting.