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
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.