Hello all, Can somebody help me with virtua...

[Eelco_de_Gee]

Hello all,

Can somebody help me with virtual columns?

I have this appformula - =SUM(SELECT(Expenses[Value], Expenses[Category] = Categories[_THISROW]))

What I try to get is:

The SUM of each Value from a specific Category.

Verifying the formula gives me an all good status, but when I test it, it remains 0. Like it doesn’t make the calculations at all.

Any tips how to make such formula?

[Fernando_Lopez1]

Try this SUM(SELECT(Expenses[value], [Category] = [_THISROW].[Category]))

[Eelco_de_Gee]

@Fernando_Lopez Mad Dog, that worked thanks man.

[Fernando_Lopez1]

You’re welcome