Help with Aggregation within a set analyisis expression

[#1]

Hi Guys,

Wondering if someone can help, im trying to aggregate this set analysis expression by service_id , ive tried a few things and im not having any luck. It doesn't seem to change the values has anyone had this sort of problem before ?

sum(aggr(sum({1<service_state = {'installed'}, m_ref=(P({1<portfolio_class = {'Managed Networks', 'Public Cloud Services', 'Managed Apps (on public cloud)', 'Hybrid & Private Cloud Services', 'Managed AWS/azure platforms', 'Managed apps on AWS/azure'}, service_state = {'installed'}>}))>}service_annualised_arv),service_id))

Thanks

Sarah

[sunny_talwar]

May be add your set analysis to outer aggregation also

Sum({1<service_state = {'installed'}, m_ref=(P({1<portfolio_class = {'Managed Networks', 'Public Cloud Services', 'Managed Apps (on public cloud)', 'Hybrid & Private Cloud Services', 'Managed AWS/azure platforms', 'Managed apps on AWS/azure'}, service_state = {'installed'}>}))>}

Aggr(Sum({1<service_state = {'installed'}, m_ref=(P({1<portfolio_class = {'Managed Networks', 'Public Cloud Services', 'Managed Apps (on public cloud)', 'Hybrid & Private Cloud Services', 'Managed AWS/azure platforms', 'Managed apps on AWS/azure'}, service_state = {'installed'}>}))>} service_annualised_arv), service_id))

[vinieme12]

can you try

sum(TOTAL <service_id> aggr(sum({1<service_state = {'installed'}, m_ref=(P({1<portfolio_class = {'Managed Networks', 'Public Cloud Services', 'Managed Apps (on public cloud)', 'Hybrid & Private Cloud Services', 'Managed AWS/azure platforms', 'Managed apps on AWS/azure'}, service_state = {'installed'}>}))>}service_annualised_arv),service_id))