Solved: Calculation not Working - Page 2

Boa_Casa · 12-30-2020 08:52 AM

Hi,

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

Marc_Dillon

Then you should have 2 virtual columns in the parent table, [Related Curtains] and [Related Curtain Tracks]. You should sum with these.

SUM( [Related Curtain][Total Cost] + [Related Curtain Tracks][Total Cost] )

I’d advise searching for the Inventory Management Sample App where you can see examples of a proper parent-child setup and the summing across children.

View solution in original post