'}' error

[Beginner]

Hi,

I'm trying to count multiple items within the same field. I tried count() & count() but the result was way off. 

I've tried this now: 

count({<[Client]={'A'}> + <[Client]={'B'}> + <[Client]={'C'}>[Apples]}) 

But from this, I get the error: '}' expected

I'm not sure what I'm missing here.

Also, will the above expression actually count (total) number of apples for Clients A, B and C?

[sunny_talwar · Accepted solution]

I think this can be simplified to this

Count({<[Client] = {'A', 'B', 'C'}>} [Apples]) 

[Øystein_Kolsrud · Accepted solution]

I think you need to move the '}' to the left of '[Apples]' like this:

count({<[Client]={'A'}> + <[Client]={'B'}> + <[Client]={'C'}>}[Apples])