Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I think this can be simplified to this
Count({<[Client] = {'A', 'B', 'C'}>} [Apples])
I think you need to move the '}' to the left of '[Apples]' like this:
count({<[Client]={'A'}> + <[Client]={'B'}> + <[Client]={'C'}>}[Apples])
I think this can be simplified to this
Count({<[Client] = {'A', 'B', 'C'}>} [Apples])
I think you need to move the '}' to the left of '[Apples]' like this:
count({<[Client]={'A'}> + <[Client]={'B'}> + <[Client]={'C'}>}[Apples])