Forum Discussion

JOSELUISMTZRMZ1's avatar
JOSELUISMTZRMZ1
Icon for Helper I rankHelper I
4 years ago
Solved

How to summarize columns when them could appear or not every update data

Hello Everyone   I have a Transform where I used Unpivot option to make the values of a column be columns then I want to add 3 new columns to summarize ABCD, EFGH, IJKL.  This transform wor...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    each List.Sum(Record.ToList(_))

KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Icon for Impactful Individual rankImpactful Individual
4 years ago

Hi JOSELUISMTZRMZ1 ,

 

I am not sure if I am following. What is the sum pattern? Sum of all the CVHOLD at row level?

Use wdx223_Daniel 's proposed formula and it should work.

 

Consider the first column is [MSPN+LOC_Name]. 

 

Add a custom column:

List.Sum(List.RemoveFirstN(Record.ToList(_),1))

 

Regards

KT

 

Regards

Kerwin

JOSELUISMTZRMZ1's avatar
JOSELUISMTZRMZ1
Icon for Helper I rankHelper I
4 years ago

My first images were an easy example what I'm trying to do but after taking a look on previous steps I could get the results what I need with both your suggestions wdx223_Daniel KT_Bsmart2gethe .

I also want to thank rohit_singh this article is also functional. 

 

each List.Sum(Record.ToList(_))  is the solution if you want to sum without to indicate columns name

 

Thanks!!!