Formula returning 1 if sum of Column A is 0, otherwise 0, not working for one specific row

Question

I have a simple sum column and a simple if statement in sum 0 that says "if sum antal=0 then 1 else 0"

But on the last row it returns 0 instead of 1.

I have tried to change the number format and i have looked at the data in the column summed up. It should work like all the other rows.

These are the numbers being summed on that specific problem row. I tried to make a dimension that check if the sum antal is greater than 0 and on this specific row it returns true, but not on all the other 0 sum rows.

Michael Christensen · Accepted Answer · 2025-06-10 10:53:59Z

0

There was an underlying issue in the dataset i was summing on, unfortunately i don't remember the specific details, but i think it was something with hidden decimals. I did get it to work in the end.

answered Jun 10 at 10:53

Michael Christensen

421 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Formula returning 1 if sum of Column A is 0, otherwise 0, not working for one specific row

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related