Hi
I am using this formula with Yes = 1/ No= 0, but the Column B doesn’t give me a value. That is happen always with the column that are before the / operator.
Example:
What is clutter]),0)
that occurs twice in your expression?
IFS() will return blank if you don’t have a matching expression. Thus, IFS(ISNOTBLANK([Column A]),0)
will return blank if the Column A value is blank.
Sorry
You are right was a mistake.
IFS([Column A]=YES,1)+IFS([Column B]=YES,1) / IFS(ISNOTBLANK([Column A]),0) +IFS(ISNOTBLANK([Column B]),0)
The situation is that the Column B doesn’t give me a value, when I choose Yes and That happen always with the column that are before the / operator.
Also keep in mind order of operations. The expression you gave will be evaluated as follows:
IFS([Column B]=YES,1) / IFS(ISNOTBLANK([Column A]),0)
IFS([Column A]=YES,1)+
result of above +IFS(ISNOTBLANK([Column B]),0)
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |