Forum Discussion
Calculate Percentage
Im working with this table that shows a list of workers, the columns are tasks where "1" represents that the worker was able to do it while "0" means they failed. I want to calculate their score in p...
Nathaniel_C
Community Champion
Community ChampionHi Ivan9485 ,
Try this:
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Score =
var _task1 = MAX(Table(Task1)
var _task2 = MAX(Table(Task2)
var _task3 = MAX(Table(Task3)
var _task4 = MAX(Table(Task4)
var _task5 = MAX(Table(Task5)
Total = _task1 + _task2 +_task3 +_task4 +_task5
Percentage = Divide(Total,5)
return Percentage