Forum Discussion

karun_r's avatar
karun_r
Microsoft Employee
8 years ago
Solved

Problem with a computed column

I am using the below formula to generate a computed column

 

Organization =
IF(ISBLANK(ColumnA),
IF(ISBLANK(ColumnB),
ColumnC,
ColumnB),
ColumnA)

 

All the three columns (ColumnA, ColumnB and ColumnC) are of text datatypes. But I am seeing the error

 

expressions that yield variant data-type cannot be used to define computed columns

 

with the computed column. Any idea what  could be the reason?

Need Help
  • karun_r's avatar
    karun_r
    8 years ago

    Thanks for the reply but I figured out the root cause for this. It was because of some null values in the incoming data. The preview was misleading me. Once I refreshed all the datasets I stumbled upon the rootcause.

2 Replies

  • fhill's avatar
    fhill
    Resident Rockstar
    8 years ago

    Can you post some sample raw data so we can test out?  Your code seems correct, so there are probably external factors at work...

    • karun_r's avatar
      karun_r
      Microsoft Employee
      8 years ago

      Thanks for the reply but I figured out the root cause for this. It was because of some null values in the incoming data. The preview was misleading me. Once I refreshed all the datasets I stumbled upon the rootcause.