Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Creating a Formula on an Exception aggregation Total Column

Hi SDN Community,

I have the following scenario

Column A Column B Column C

value1 1 value1 divided by total of column B

value2 1 value2 divided by total of column B

value3 1 value3 divided by total of column B

Totals

Value123 3

I have created a CKF with only th value 1 in it and put in the column B, and placed after Aggregation on the properties of the CKF to derive the total result for column B successfully

I now want to create in Column C a formula which divides the value by the result of the column B.

I have tried using the formula

Column A / SUMCT Column B

where the SUMCT Column B value should be = 3

Does anyone have any ideas for the above.

Thank you.

Simon

Former Member
Not what you were looking for? View more on this topic or Ask a question