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

[AaronTerry]

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]

Aaron_Terry:

I’d like to add the total of the virtual column Remaining Budget to the Related Costs

How? [Related Costs] is a List of Refs. To what exactly do you want to add the [Remaining Budget] value to?

[AaronTerry]

Thanks for the quick response Marc!

I’ve been attempting to alter the app formula for [Related Costs] to also include [Remaining Budget]. Is it possible to LIST() two select or filter functions?

[Marc_Dillon]

Aaron_Terry:

I’ve been attempting to alter the app formula for [Related Costs] to also include [Remaining Budget].

Again, how? What is your goal, or desired final result here?

Aaron_Terry:

Is it possible to LIST() two select or filter functions?

Not sure what you’re asking. Both SELECT and FILTER will return List data types, and Lists can be added together, like:
LIST(1,2) + LIST(3,4)
would result in
LIST(1,2,3,4)
but I can’t see how this would produce a desirable result for you here.

---

---

If I were to zoom out and try to see the big picture here, I would assume that you would want to calculate a [Remaining Budget] by subtracting a SUM() of all [Related Costs] from an initial budget amount. Is this by chance what you’re trying to do here?

[AaronTerry]

Yes, my [Remaining budget] column is functioning perfectly. I’d like to now show that value as well in the pie chart if possible! I may be chasing something that should be approached another way.

[Marc_Dillon · Accepted solution]

Aaron_Terry:

I’d like to now show that value as well in the pie chart if possible!

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.