Forum Discussion

drwinny's avatar
drwinny
Icon for Helper I rankHelper I
5 years ago

checking if multiple training modules are complete and mark as completed

Hi All,   I need to check if a user has passed multiple training courses or not and then return yes/no, true/false answer  In the example joe bloggs1 did not complete all the training so that woul...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

drwinny , Try a new column like

 

 

New column =
if( countx(filter(Table, [UserName] =earlier([UserName])), [Training Code]) = countx(filter(Table, [UserName] =earlier([UserName]) && [passed] =True()), [Training Code]) , true(), false())

 

 

true() is for boolean true. else you can use = "True"

drwinny's avatar
drwinny
Icon for Helper I rankHelper I
5 years ago

Thanks, both, I will give them both a try