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 an...
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.

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.