Forum Discussion

xile015's avatar
xile015
New Member
8 years ago
Solved

using a calculated column for conditional column

i have an excel file with 5 columns: name, quiz1, quiz2, quiz3, and quiz4 the name column has the names of the students (unique) and each of the quiz columns have their scores for each quiz afte...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi xile015,

     

    There isn't a problem in this scenario. The column created in the Data view won't appear in the Query Editor. You can create a Conditional column in the Query Editor instead.

    using_a_calculated_column_for_conditional_column

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi xile015,

 

There isn't a problem in this scenario. The column created in the Data view won't appear in the Query Editor. You can create a Conditional column in the Query Editor instead.

using_a_calculated_column_for_conditional_column

 

Best Regards,

Dale