Forum Discussion

outdoorlife's avatar
outdoorlife
Copper Contributor
Apr 04, 2019

Automated Workflow to provide percentage in one column based off of results from another column in

Automated Workflow to provide percentage in one column based off of results from another column in a List.

 

Hello! I am a very new user with SharePoint, so any help will be appreciated. 

I have List with multiple columns. Of those Columns I have one Labeled [Issue Resolved] and it is a Choice type with a Yes or No option. Another column is labeled [% of No Res to Total Contact] and I have this one as a Number type to show as a percentage. 

 

Can I build an automated Workflow in Designer that will compare the "No's" in [Issue Resolved] column against all responses in [Issue Resolved] column (caclulation to get a perecntage. E.g., 31 no's / 99 total entries * 100 = 31.31%) and get that number to populate automatically in the [% of No Res to Total Contact] column each time a new entry is created and submitted?

 

5 Replies

  • Hello outdoorlife,

     

    If you are trying to create a running total of all issues you will need a separate list to store the calculation. The "% of No Res to Total Contact" column would reside in the additional list.

     

    A workflow that triggers on modifies in the base list, with "Issue Resolved", can be created that performs the calculations and stores it in the separate list.

     

    I don't have a lot of experience with Designer Workflows but in O365 Flow this is possible.

     

    I hope this helps.

     

    Norm

    • outdoorlife's avatar
      outdoorlife
      Copper Contributor

      Hello Norman Young,

       

      Could you provide a link or point me in the right direction on how to build that Workflow in order to achieve your suggestion? I am extremely new to using SharePoint, let alone building a Workflow. I appreciate your response! 

       

      Thank you!

Resources