Problem of memory with sum(if(isnull(X),Y))

[azaia_synt]

Goodmorning,

I have a problem of memory using the formula in object.

I must count the number of record that have some field null; have I an alternative to the formula sum(if(isnull(X),Y))? because with 200K record the application is not able to show me the table where I use the formula.

Thanks

[Clever_Anjos]

How those fields are related? Are they on same table?

[azaia_synt]

Yes they are on the same table and all X field are string, Y instead is a integer value to 1.

[Clever_Anjos]

Please check if SUM(Y) - SUM({<X={"*"}>}Y)  brings same result and performs better