total in set analysis irrespective to column name

[vipingarg23]

Hi Team,

I have below straight table:

Transport(Dimension)	Expression (What is coming)	Expression(What I want)
A	value corresponding to A	value corresponding to A and B
B	value corresponding to A	value corresponding to A and B

I am using below set analysis but not working:

sum({$<TRANSPORT_NAME={'A','B'}>}cost)

Can anybody help me?

[vipingarg23]

Sorry..typo mistake in Expression(What is coming)...In B cell, it is coming value corresponding to B

[vishsaggi · Accepted solution]

Try this?

sum(TOTAL {$<TRANSPORT_NAME={'A','B'}>}cost)

[tresesco]

Try using Total keyword like:

=sum( total cost)

[vipingarg23]

Great...It is working fine....thanks a lot...You made my day....