A New Home in the New Year for SAP Community!

Exciting times ahead for the SAP Community! We've outgrown our home, so we'll be migrating to a new platform later this year. Let's continue the journey together!

Oct 30, 2007 at 03:41 PM
# roll up issue

I have 3 columns, A, B, C. A and B are selections, C is a formula. B has a value of 0 most of the time. When ever, B has a value other than 0, C takes the value of B. If not, C takes the value of A.

Basically, formula for C is

C = (B<>0)**B + (B==0)**A

The roll up gives me a problem. I have the calculate result as "summation" option checked. It doesn't sum the values in column C. It applies the same formula at the region/district level and gives an incorrect value. Since B has a value at the roll up level it gives the value of B as the result which is incorrect.

How can I make it sum all the values of C?