I have a Quotation App in which I have multiple Tables such as Customer ( Used for user input of customer details) and various other Quote calculation tables for each of product such as Window Blinds,Carpet etc various other products we deal in (Used for input of measurement and product selection and calculation of cost of product)
In customer Table I need to show total per customer based on the product input done across various table so have added a Virtual column "Total Cost"and have added the formula below :
SUM(LIST(0)(Curtain Track[Total cost(Curtain Track)] + (Curtain[Total Amount (Curtain)]) + (Floor Covering[Total cost (floor covering)])))
Where in Curtain Track is the name of the table and Total Cost (curtain Track) is the column which shall have final amount figure for that table and so on with the other products.
Though the formula is not showing any error, the total cost field is remaining as blank and not showing any value, It would be helpful to know where I am going wrong