Adding grand total for columns

[RRAINA31]

Hello community,

I am looking to add a grand total as an additional column and hoping someone can help.

I have four columns namely A, B , C & D. I want to sum all the rows horizontally and have created a new column called G. Now I also see I can achieve this by Math formula node but there is an issue because my column names are created by rule engine.

So C column can be absent in the next month because the data is not present and that would fail the math node because there is no Column C. Is there a way to handle this ?

Thanks,
R

[lelloba]

Hi @RRAINA31,

I found this post that might help you:

Check if Column Exists in Column Expressions Node

Hello, I have a column that exists within some files and not in others. Thus, when running a loop through reading all the files, it does not always appear. I am running into a problem with the Column expressions node that it throws an error because the column I am wanting to use (if it exists) does not exist. Essentially, I want to write an expression that says: If the column(“column1”) exists, then do something, else, do something different I have tried something along the lines of with no …

Have a nice day,
Raffaello Barri

[HansS]

Hi @RRAINA31

Go for the Column Aggregator node.

And be sure to check the radio button on the left dialogbox, to make sure every column in your dataset will be used to calculate the sum.

gr. Hans

[RRAINA31]

Thanks this might help but sorry I should have mentioned. I have more columns than just then A, B, C & D which I don’t want in the total.

[rfeigel]

See if this helps.

Row & Column Sums WF – rfeigel

[HansS]

Hi @RRAINA31

In case you have columns you don’t want to have in the total sum, place these columnnames in the left panel. The won’t be part of the calculation because of the “enforce exclusion”.

gr. Hans

[RRAINA31]

Thank you, this worked for me.