Forum Discussion

markus_zhang's avatar
markus_zhang
Icon for Advocate III rankAdvocate III
7 years ago
Solved

[Excel] Expressions that yield variant data-type cannot be used to define calculated columns.

Hi experts,   I'm getting this strange error in Excel Power Pivot:   Expressions that yield variant data-type cannot be used to define calculated columns.   Now if I look at the columns that ha...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi markus_zhang,

     

    This error prompts when there existing two different data types in formula. In your scenario, you used both number value (zero 0 ) and text value ( [NTK] ) in  single column.

     

    You can replace the 0 with BLANK() or "" to avoid such an error.

     

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi markus_zhang,

 

This error prompts when there existing two different data types in formula. In your scenario, you used both number value (zero 0 ) and text value ( [NTK] ) in  single column.

 

You can replace the 0 with BLANK() or "" to avoid such an error.

 

 

Best regards,

Yuliana Gu