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

(Eelco de Gee) #1

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 López) #2

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

(Eelco de Gee) #3

@Fernando_Lopez Mad Dog, that worked thanks man.

(Fernando López) #4

You’re welcome