Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Question about Updating Data

Hi,

I have a main sales table that has to updates every month, so the source file that populates the sales table would have more data every month, this means every month when the file gets more data, the sales table should also be updated with more data. My question is that I want to create some calculated columns on the sales table, will these calculated columns still work once the sales table gets updated?

Thanks.

Need Help

2 Replies

  • johncolley's avatar
    johncolley
    Solution Sage
    4 years ago

    Hi Anonymous , It will continue to work, as long as the fields used in the calculated column aren't removed or renamed.

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, Anonymous 

     

    If your data table is on the large side, it is recommended to use measure calculation. Similarly, the calculation will remain in effect as long as the columns in the calculation are not deleted and renamed.

     

    Best Regards,

    Community Support Team _Charlotte

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