cancel
Showing results for 
Search instead for 
Did you mean: 

Count using a Key Figure

Former Member
0 Kudos

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?

View Entire Topic
Former Member
0 Kudos

Hi,

Create a RKF in which you can restrict with material and sales. In another CKF you can write a formula to check whether it is eual to zero or not and use the count function to count the records with no zero.

Else create a condition to filter sales with zero values and in the columns, in the new formula use count function for sales.

Hope this helps you..........