Count At_Kt as 1 if subject Mark is less than 40 and calculate total nos of At_Kts. Eg: If any student has less then 40 marks in 2 Subject then ATKT count is 2 ,If any student has less then 40 marks in 3 subject then ATKT count is 3 .......not get result

Help Community
, ,
1

image
image1366×768 80.4 KB

MarksheetTask Data.xlsx (12.8 KB)

2

Marksheet Data .xlsx (14.4 KB)
Main (5) (1).xaml (64.4 KB)

in that main file your doubt was cleared

3

Hi @sohil_bagwan,

What about this workflow

Workflow

image
image604×745 19 KB

Xaml
Main (1).xaml (9.9 KB)

If(CInt(row(“English”).ToString)>40,0,1)+
If(CInt(row(“Urdu”).ToString)>40,0,1)+
If(CInt(row(“Physics”).ToString)>40,0,1)+
If(CInt(row(“Math”).ToString)>40,0,1)+
If(CInt(row(“Chemistry”).ToString)>40,0,1)+
If(CInt(row(“Biology”).ToString)>40,0,1)

Thanks,
Rajkumar

4

Thanks Mam

5

Thanks RAJ

6

you got the output ?

7

can we use modern excel activity without linq

8

@RajKumar_DC
Why we used 40,0,1
Can we use only 40… why there is 0,1? Any reason

9

Hi @yashmahale30 ,

Welcome to UiPath Community!

If(CInt(row(“English”).ToString)>40,0,1)

this is if condition so if it is CInt(row(“English”).ToString)>40 true the intOut value is 0 or false the intOut value is 1

Thanks,

10

Thank
you
brother
:blush: