Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)