I want an advice from an expert.
I have a table that includes multiple calculated columns that depend on other calculated columns in the same table.
All the calculated expressions are direct additions, subtractions and multiplications.
I read that calculated columns inside tables are not recommended, is this true?
What are the drawbacks of this design? What happens when the table size increases?
Is there a risk of wrong calculations or data corruptions in the table?
What about the forms related to this table, will they become slower?