Math operators (`/` operator)

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:

  • IFS([Column A]=YES,1)+IFS([Column B]=YES,1) / IFS(ISNOTBLANK([Column A]),0) clutter]),0)+IFS(ISNOTBLANK([Column B]),0) clutter]),0)

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:

  1. IFS([Column B]=YES,1) / IFS(ISNOTBLANK([Column A]),0)

  2. IFS([Column A]=YES,1)+ result of above +IFS(ISNOTBLANK([Column B]),0)