Same SUM value for every record of the column

letmein

New member
Joined
Jan 25, 2017
Messages
7
Reaction score
0
Points
0
Location
london
Excel Version(s)
2013
Hi,

I may have a very simple qestion, but haven't find the answer so far, looking on many forums, including this.
I would like to add a "SUM" column for a previous (number) column, showing the same value in every row (=the sum of all numbers of previous column)

Like: I have column "A" with number, and I would like to create column "B" as follows:
Column "A" name is: "EpicSP"

A, B
1, 13
2, 13
3, 13
5, 13
2, 13

I know the
  • Transform > Number Column > Statistics > Sum, but that will collapse my table to a single value of the sum, instead of repeating the sum value for each row.
  • I also tried Add column > custom column > custom column formula > =List.Sum(#"Grouped Rows"[EpicSP]),
then I get the error message: Expression.Error: The name 'Grouped Rows' wasn't recognized. Make sure it's spelled correctly.

  • When entering = List.Sum([Epic SP])
I get "Error" values for all rows. Expression.Error: We cannot convert the value null to type List.


Could any of you fine gents help me?
Many thanks!
 
Last edited:
The solution at the second bullet looks fine, but you need to make sure to replace #"Grouped Rows" with the name of your previous step.
 
That worked, many thanks for the quick solution!
 
Back
Top