Forum Discussion

chulymda's avatar
chulymda
Frequent Visitor
5 years ago

ABCD classification:


I need to do an ABCD classification:

A >0.7
B >0.9
C >= 1
D Values ​​with negative results

I need to measure the value of sales, and the # of products in each category

I've been editing the SQLBI ABC pattern for a long time but I can't calculate the number of products in each category

Need Help
Tips and Tricks

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    chulymda I was going to point to you SQLBI ABC analysis and if you follow that it should work, not sure why it is not working for you.

    • chulymda's avatar
      chulymda
      Frequent Visitor
      5 years ago

      parry2k :

          The SQLBI pattern is not intended for a category with negative values ​​(D). I'm sure editing the code correctly should work.

      It is what I am not achieving I need help with that!

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Community Support
        5 years ago

        Hi chulymda ,

         

        Why there is negative results in your data? The class was divided by cumulated sales. Would you please try to modify the abcclass code to :

         

        AbcClass =
SWITCH (
    TRUE,
    CumulatedPct <= 0,"D",
    CumulatedPct <= 0.7, "A",
    CumulatedPct <= 0.9, "B",
    "C"
)

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

        Best Regards,

        Dedmon Dai