Skip to Content
0
Former Member
Aug 09, 2006 at 01:55 PM

Count using a Key Figure

171 Views

Hi All,

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?