Have the below req:
Need to calculate the count of orders, which have the order allotment month along with delivery month and inspection month.
1. If for an order, if there is an order allotment month, we should also verify if it has got the inspection and delivery months (Everything in same month). Then we need to give such count. In addition to this, if there is a inspection month available, then we should NOT consider delivery month.
2. For another count, everything is similar except that the order allotment month must be in different month than the inspection and delivery ones.
Where can I achieve such count based on conditions...Pls guide on COUNT