Hii guyz …I am new to UiPath …please help me to how to calculate percentage of multiple columns such as
I have I have 7 subjects marks And I want calculate total then then calculate percentage
Welcome to the community
You can use excel formulas for this
Use a write cell with value as "=Sum(E2:J2)"
and the cell as "k2"
And then use auto fill range K2:K11 then all the rows will have sum
And for percentage… use write cell again on L2 with value as "K2/600"
assuming total is 600 change accordingly
And use auto fillrange again
Cheers
Thank you so much for your valuable Suggestions
Use Write cell activity:
(SUM(E2:J2)/600)*100&“%”
Thanks
Thanks alot Kalpesh
Again I have to count AT_KT for if subjects marks is < 40 then aAT KT count become 1 for one subject, If two subjects marks is <40 AT KT count should be become 2 …
In Advanced Thank you so much
Please try this.approach would be same again
=COUNTIFS(E2:J2,">40")
Hope this helps. please mark if donr else if any errors happy to help
Cheers
Work after I did like this =sum(E2:J2)/600*100
Thank you so much Anil Sir
Cheers
It’s work thank you so much
Cheers:blush:
I have used rank function to do ranking as per the Percentage…
=RANK(L2,L2:L11,0)
But it return duplicate value too …such as 1111 22 in column instead of unique ranking vise
Cheers
Hii I want to right NA in rank column who has atkt…how to do that help me
Cheers
Please use this. and please try to amintain one topic for one question.that way it would help to understand the conversation to others as well
"=IF(M2>0,=RANK(L2,$L$2:$L$11,0),""NA"")"
Please mark as resolved if solved. And for subsequent questions on other topics feel free to open a new ticket/topic
cheers
strDate = “UiPath, RPA.Developer”
I want to replace . Dot where is comma, and in .dot replace with comma
How ?
Cheers