6 Replies Latest reply: Aug 3, 2012 9:03 AM by Clemens-A. Scherer

# Problems with an ABC-analysis

Hello,

I hope you can help me out. Sorry, if I´m in the wrong area, but it`s my first posting.

I´m trying to make an ABC-analysis. For that I accumulate the amount of articles in column 5. In the next step I want to say with an  if-formula, if this article is an A-, B- or C-Article. If the amount is less than 80% it is an A-article, between 80 and 95% it is an B-article and over 95% it is an C-article.

With this formula it doesn`t work...

if( Column(5)  < 0.80 , 'A', if( Column(5) > 0.95 , 'C', 'B'))

Have you got an idea

best regards,

Clemens

• ###### Re: Problems with an ABC-analysis

IMO better way will be :

- paste \$(Anteil kum.)= rangesum(above(Count(PACKMENGE) / count(TOTAL(PACKMENGE)),0,rowno())) as amount  cum. and make no acumulation

- paste =if( Column(4)  < 0.80 , 'A', if( Column(4) > 0.95 , 'C', 'B'))

• ###### Re: Problems with an ABC-analysis

Hello,

But now there is a new problem: I sorted the table descending by 'positions'. Now the sorting doesn`t work any more. Any idea?

Thanks!

• ###### Re: Problems with an ABC-analysis

because you still have accumulation in amount  cum. right?

select No Accumulation

BTW - if you use rangesum(above(..... you can only sort dimension (interactive sort does not work)

which is strange:/

anybody knows why?

• ###### Re: Problems with an ABC-analysis

no, I did as you said and selected 'No Accumulation'.

I do also wonder why the sort does work with dimension but not with the formula...

• ###### Re: Problems with an ABC-analysis

Hi Clemens,

Probably this blog about abc analysis I wrote some time ago is interesting for you: http://www.quickqlearqool.nl/?p=1086

Regards William

• ###### Re: Problems with an ABC-analysis

Hi William,

this is nice, thank you very much!

Regards,

Clemens