Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Why not a straight table instead of a text box?
You can use set analysis
sum( {<Requirement={'Travel'}>} USD)
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)
Thank you so much, it hepls
Thank you for your response, it's solved
Thank you for your response, it's solved