Count a Field

[rmdnkevin]

Hi, everyone.

I have this kind of table :

I want to make a text object that only count each sum, such Travel = 3798, Shop = 278, etc.

How can I count that in an expression ?

Thank you

-Kevin

[dapostolopoylos]

Why not a straight table instead of a text box?

[pooja_prabhu_n · Accepted solution]

You can use set analysis

sum( {<Requirement={'Travel'}>} USD)

[sergio0592]

Hi, try in text box with :

='Requirement=Travel'&sum( {<Requirement={'Travel'}>} USD)&chr(10)&'Requirement=Shop'&sum( {<Requirement={'Shop'}>} USD)&chr(10)&'Requirement=Education'&sum( {<Requirement={'Education'}>} USD)

[rmdnkevin]

Thank you so much, it hepls

[rmdnkevin]

Thank you for your response, it's solved

[rmdnkevin]

Thank you for your response, it's solved