How to sum a column only if a checkbox is not checked?

Hello,
I want to sum $ from a column only if a checkbox on each row is not check.
I test sumif([Les projets].[CA référence],[Les projets].Signe.IsBlank()) but it doesn’t work.
Someone could help me ?

It’s better to use the filter function in this case. You need to filter the rows where the checkbox is Unchecked, then return the values of the amount column and sum it:
[Les projets].filter([Signe]=false()).[CA référence].sum()

2 Likes

Excellent ! Thx a lot for your reply. It’s perfect

1 Like