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


MarksheetTask Data.xlsx (12.8 KB)

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

in that main file your doubt was cleared

Hi @sohil_bagwan,

What about this workflow

Workflow

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

Thanks Mam

Thanks RAJ

you got the output ?

can we use modern excel activity without linq

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

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,

Thank
you
brother
:blush: