Sum Select Minor Problem

[Moray]

Good Morning

Really sorry this problem has been covered dozens of times.

I am using this formula

SUM(SELECT(Latestledger[Credit], [Account] = “Subs”))

I have setup a virtual column in the table Latestledger  the total I keep getting is 

Subs Sum  The Account data is a dropdown which references another table containing the account names.  Have tried a few things but no joy.  Wondered if it was because it was a reference to a table or well not quite sure.  Thank you for any pointers.

£0.00

[TeeSee1 · Accepted solution]

Do you get any data/rows with just

SELECT(Latestledger[Credit], [Account] = "ID15")

?

If not, do you actually have rows in Latestledger data source (i.e. gSheet) with Account columns having "ID15" at all?

[TeeSee1]

For a ref column, you have to equate it with a key value, NOT a label.

[Morayweb]

Hi TeeSee

How would I do that then.

[TeeSee1]

[Account] = "key value corresponding to Subs"

[Morayweb]

Have tried this too

SUM(SELECT(Latestledger[Credit], [Account] = ID15))

[TeeSee1 · Accepted solution]

Do you get any data/rows with just

SELECT(Latestledger[Credit], [Account] = "ID15")

?

If not, do you actually have rows in Latestledger data source (i.e. gSheet) with Account columns having "ID15" at all?

[Moray]

Hi thanks for reply

No I dont get any data.  I am using the new appsheet database not a gsheet. I have attached an image of my tables if that helps.

[Moray · Accepted solution]

TeeSee1

I have replaced Account with ID and =15 and seems to be working now.

Thank you.

[Moray]

Do you mean the id for subs etc rather than the actual label subs