Hi,
It is dynamic that today I may receive 4 columns; tomorrow I may receive 5 columns.
I want a new column which shows addition of these all coulmns
Is it possible to use formula something like (A1:A1) ?
Solved! Go to Solution.
Hi @nikhilg19
In this case you want to add a record id, transpose your data, sum grouping by recordID and join back to the original data set
Workflow
Results for 4 columns
Results for 5 columns
Dan
Hi @nikhilg19
Record ID, Transpose (Checking Dynamic and Unknown Fields) and Summarize Tool, then bring it back to your dataset using Cross-Tab and a Join Tool.
Cheers,
Hi @Thableaus
We seems to both be active around the same time. Are you based in Europe? I'm in Canada but I start early.
Dan
Cool! I'm in Brazil. I think it's a 2 hour difference from Toronto (not so sure what your time zone is in Canada).
Cheers,