I have an issue using COUNT in a query. The issue is that I have to count the no. of material based on a certain KF, say sales. If the sales amount or value is non-zero then the material has a count of 1. If the sales amount is zero then the count is 0.
Now, I need to display the no.of materials in a particular period with sales in that period. Could you please let me know how is this possible?