Calculated Column

[Anonymous]

Hi Experts,

First, I have split the column personname in query editor and wrote some logic on it. is it possible to import same coulmn(personame) from Db

Secondly,I want to write an If condition and need to create a separate column based on this condition

Eg;

Person               condition column(If person is not null then Name else Other)

aa                                Student

bb                                Student

null                               Others

cc                                 Student

dd                                Student

null                               Others

[Anonymous · Accepted solution]

@Anonymous 

1. You can just duplicate the original "personname" column in Query Editor, then wrote logic on the copy.

2. 

Calculated Column  = IF([Person] = BLANK(), "Others",[Person])

Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38]

@Anonymous 

it looks easy

Column = if([Person] = "null", "Other", [Person])