Forum Discussion

colsand's avatar
colsand
Frequent Visitor
8 years ago
Solved

ANALYSIS TABLE/COUNTX FUNCTION

I am trying to create a small analysis table which gives a breakdown of the number of items which fall within certain lead times.. In excel, this would be a simple matter of using COUNTIF/COUNTIFS bu...
Need Help
Tips and Tricks
colsand's avatar
colsand
Frequent Visitor
8 years ago

Many thanks for your help, that appears to be what I need.

 

Regards.

 

Colin

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi colsand

 

I noticed that some of your Lead Times fall in none of the Clusters. For example Leadtime greater than 200

 

You can always go back and revise the Start and End ranges of your Parameter Table or Add new cluster

 

 

  • colsand's avatar
    colsand
    Frequent Visitor
    8 years ago

    Yes, thank you, I will set the end point way over the maximum to allow for this.

     

    Regards.

     

    Colin