Hi
I am trying to count in workflow template with Start and end
<<Start: orderby(Select(Jobs rรฉpรฉtรฉ dernier mois[IDFERMETURE],contains([Nom du technicien],โFusionComโ),TRUE),[Nom du technicien])>>
<<[Nom du technicien]>>
<<count(Select(Jobs rรฉpรฉtรฉ dernier mois[IDFERMETURE],and(contains([Nom du technicien],โFusionComโ),[_THISROW].[Nom du technicien]=[Nom du technicien])))>>
<>
it returne error : Error in expression โ[_thisrow].[Nom du technicien]โ : Unable to find column โ_thisrowโ.",
@Simon_Langelier_Cont
It should be like this:
COUNT(
SELECT(Jobs rรฉpรฉtรฉ dernier mois[IDFERMETURE],
AND(
CONTAINS([Nom du technicien],"FusionCom"),
[Nom du technicien]=[_THISROW].[Nom du technicien]
)
)
)
Thanks but it give me the same error
Itโs probably besause I am in report for Entire Table
@Simon_Langelier_Cont
Correct. You can use [_THISROW] deref only with row level actions.
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |