letmein
New member
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
Could any of you fine gents help me?
Many thanks!
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: