Question:
Hi all,
I want to use ABC classifiction in a BEx Query, but the column results
should be 'A' or 'B' or 'C'. How can I handle this?
I don't want to use VBA. The ABC classifiction is compute on the previous
column, e.g.
Column1 <= 0.5 then Column2 is A
Column1 <= 0.75 then Column2 is B
Column1 > 0.75 then Column2 is C
Any ideas?
Thanks
whusten
Answer:
Put a calculated key figures with a different IF in each column.
Ch
Answer:
Hi CH,
that's what I did,
first column yields 1 for condition 1, else 0
second column yields 2 for condition 2, else 0
third column yields 3 for condition 3, else 0
the fourth column is a summation of all with
result either 1 or 2 or 3.
But I do not know how to replace 1 by A
2 by B and 3 by C