Filtering synthax problem

1

Hello,

I’m trying to adding some durations from a table filtering by a column value but it doesn’t work. I must not understand something but I don’t know what.

heures.duree.Filter(heures.projet_phase=thisRow.projet_phase).Sum()

or

heures.duree.SumIf(thisRow.projet_phase=projet_phase)

2

Hi @Charles_Coiffier what is the column value that you want to filter on?
Lets say it is “Apples”
Then you could try -
heures.Filter(projet_phase=“Apples”).duree.Sum()

Let me know if this works.

3

Thanks a lot. It’s crazy, the more we simplify the code better it’s working…

1 Like