as an example: I want to choose the percentage of how complete is the task ( in percentage) of an employee who works in 3 projects then calculate the difference between them. (100% - (the total of the 3 percentage values in the three projects)
closed as unclear what you're asking by Robert Lindgren, Gaurravs, Gautam Sheth, Asad Refai, Waqas Sarwar MVP♦ Jul 20 '18 at 17:27
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
While there is a way to do this, it's not going to work quite as dynamically as you would probably like.
- Modify the View where you would like this feature added
- Expand the "Totals" group
- For the Percentage Column, select the total you would like (I believe you will need to do the 100%-X portion as the consumer of the information)
- Save the View
- Now you will see the Sum of Percentages directly in the view. As you filter the list, this number will adjust to only include the items you are currently able to see.