SUM IF executing multiple times in expression

[SamQlik]

I'm puzzled by the logic being executed in  an expression when two snippets of code are used.

Firstly, if I run this piece of code, it returns 1, as expected:

=SUM(
	IF(false(),
	1,
	1)
)

However, if I modify the formula slightly and replace the success variable to be summed with an actual field, the formula returns 24 which happens to be the count of the field as well:

=SUM(
	IF(false(),
	myField,
	1)
)

Does anyone understand why this is happening and how can I get around it?

Thanks

[Or · Accepted solution]

Presumably, the first expression is evaluating once because it's just an empty function, while the second expression is evaluating once per myField value, so 24 times.

It sounds like what you're after is actually:

If(False(),Sum(Myfield),1)