Aggr problem

[DavidFoster1]

I have the following expression

=CONCAT({$<Stage.YrMthID={'297'}>} AGGR(SUM({$<Stage.YrMthId={'297'}>} [Project Stage Duration]),[Project Id],[Project Stage]),',')

I need this statement to return the results linked to YrMthId 297 irrespective of the actual selected value of YrMthId. But the behaviour I am getting is when I select a YrMthId other than 297 the result is NULL.

I have other filters that I need to include so I need to use the $.

Any ideas?

[jagan]

Hi,

Try this

I have a table like this

city	sales
blore	2300000
chennai	5600000
hyd	1000000

=CONCAT({<city={'blore'}>} AGGR(SUM({<city={'blore'}>} sales),city),',')

This expression is working, can you attach some sample file.

Regards,

Jagan.

[#3]

It works with $ sign as well.

=CONCAT({$<city={'hyd'}>} AGGR(SUM({$<city={'hyd'}>} sales),city),',')

You might have to check your other selections, that might not match the result set of YrMthId = 297, so either have to deselect it, or ignore them in set analysis.

Thanks,

Singh

[DavidFoster1]

Does it work if you make a different selection in the city field?

[#5]

Yes it does David. It works even If I clear selections for the City field. Try selecting any ID other than 297 and deselect all selections. Then one by one add your other selections and see where it is failing.

[jagan]

Hi,

It works even for a different selection in the city field, can you attach sample file.

Regards,

Jagan.

[DavidFoster1]

Thanks for testing for me. I must be doing so etching stupid in the app

Sent from my iPad