Formula error as to minus


Hi everyone.
I’m working on my assignment and my due day is around the corner.
However, I have no idea when I make a formula that sums all numbers in the same row but make it minus one only if " last age >44" is true. Even though I put -1 after the sum formula, it only shows -1 instead of (total sum -1) which I want.

Is there anyone who can help me?

Hi @danhovac ,

In your screen you use count, so change them to use sum, but it will show up depending on your database relationship.

Thx for the comment. As you mentioned, the minus doesn’t work on the count setting. So I changed to sum of the row instead. Thx

1 Like