AnsweredAssumed Answered

collection operation involving multiple columns in a single step

Question asked by nicetohaveyou on Nov 24, 2015
Latest reply on Dec 10, 2015 by eharris04

I have two lists:

List A

 

User    TechnicalSkill-PP  SoftSkill-PP TechnicalSkill-PE    SoftSkillPE

 

User1          4                       4                       3                         2

User2          4                       4                       3                         2

User3          4                       5                       3                         2

User4          4                       1                       3                         2

 

in the second list ListB is want to calculate the sum of each column and store such as

 

category    TechnicalSkill SoftSkill

PP                16                   14

PE                 12                   8

 

In the NIntex workflow, i have to use 4 querylist,collectionoperation,mathematical operation user actions.

Is it possible to avoid repetitive usage of user actions and can be made short?

 

Many Thanks

Outcomes