Forum Discussion

fabio7xavier's avatar
fabio7xavier
Frequent Visitor
6 years ago
Solved

New column based on multiple column values

I have a table like this Field 1 Field 2 Field 3 10 10 30 30 30 10 10 null 30 10 30 10 30 30 30   And I would like to generate a new column that will count how man...
  • az38's avatar
    az38
    6 years ago

    Hi fabio7xavier 

    try a calculated column

    Counter= ([Field 1]=30)+([Field 2]=30)+([Field 3]=30)
az38's avatar
az38
Community Champion
6 years ago

Hi fabio7xavier 

try a calculated column

Counter= ([Field 1]=30)+([Field 2]=30)+([Field 3]=30)