Solved: Adding a virtual column (Price) to another virtual... - Page 2

AaronTerry · 12-21-2021 07:29 AM

Hi guys, I’ve been wrestling this for a few days so it’s time to throw it out into the ether.

I have a virtual column that is filtering related costs into a list and displays them as a pie chart based on the project and property currently selected.

I’d like to add the total of the virtual column Remaining Budget to the Related Costs and I’ve tried a bunch of different methods to no avail. It seems so simple so I’m probably overcomplicating things and getting in my own way. If anyone can offer some advice I’m all ears.

Thanks in advance! I’ll attach some screenshots to help explain.

Marc_Dillon

Ahh! You really should have led with that.

Charts can only show record from a single Table. So, yes, you’ll need to approach this from a different way.

So your remaining budget value would have to be its own record within the same Table as the costs.

To achieve this, I can imagine a “budget allocation” Table, in place of your “costs” Table (really the same thing, just changing the name). Where the “remaining budget” record would get auto-created upon initial creation of the parent Project, and then auto-recalculated every time a Cost record is created/updated.

View solution in original post

Adding a virtual column (Price) to another virtual column (List)