About Mattsshop

Mattsshop · 05-09-2021

OK, I have a quote builder for my small construction company that I am working on. I have a project table that I can put markup, per hour rate and tax percentage in. Then I go to estimate items and add each item with things like item, quantity and ho...

Mattsshop · 04-21-2021

I have my app almost working and it is a simple quoting app, I am trying to total my projects from all sub totals in the estimate sheet. It says it is working but the sum value is always 0. Here is my Formula. I am fairly new so I am not sure if this...

Mattsshop · 05-09-2021

I am fairly new at this, only about 6 months. I may be calling them the wrong thing but I assume the Project is the parent and the Estimate is the child since the total cost in the Project table is calculated by all the items in the Estimate table fo...

Mattsshop · 05-09-2021

Thanks Steve, I know it has been a few days but I forgot to post that I got it working and a Virtual Column is what I needed.

Mattsshop · 04-22-2021

Thanks for the reply and help Suvrutt_Gurjar, but I still get a 0 outcome on the sum from the referenced rows in the estimate table. When I sum just Estimates[Sub Total] it works fine but that is all the rows and I want to group only rows with the sp...

My Stats

Mattsshop's Bio

Badges Mattsshop Earned

Recent Activity

Change in parent table to calculate in child

Sum from other table

Re: Change in parent table to calculate in child

Re: Sum from other table

Re: Sum from other table