Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Blank Calculated Columns after refreshing SQL Data

After creating several calculated columns in the Data view and pulling data from several related tables, I ran a refresh from SQL for the most current data. After an apparently successful update, the...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    According to your statement, I think you are getting data from SQL Server by import connection mode. Your issue is that your calculated column will return blank after you refresh your report. Please check whether the columns you used in your calculation is still ok, maybe one of them have changed to 0 or blank in your calculation.

    If this reply still couldn't help you solve your problem, please show me more details about your data model. I need to know your data format and your calculate logic.

     

    Best Regards,
    Rico Zhou

     

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

According to your statement, I think you are getting data from SQL Server by import connection mode. Your issue is that your calculated column will return blank after you refresh your report. Please check whether the columns you used in your calculation is still ok, maybe one of them have changed to 0 or blank in your calculation.

If this reply still couldn't help you solve your problem, please show me more details about your data model. I need to know your data format and your calculate logic.

 

Best Regards,
Rico Zhou

 

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