topic Re: Alternate State Set Analysis in Water Cooler

Alternate State Set Analysis

sangeeth8787 — Fri, 07 Feb 2020 20:01:09 GMT

Hi,

I have created two multi box with Group1 and Group2.

I am able to write set analysis difference between Group 1 and Group2.

How to achieve in set analysis

sum({<Group2[CountryCode] = Group1{Intracountry code}>}Value)

User had selected IntraCountryCode in Group1 Filters, but he don't want manually select CountryCode filter from Group2

I had tried following, but no luck

sum({<CountryCode = {"=(GetfieldSelection(IntracountryCode,'','Group1' "}>}Values)

Is it feasible?

Many Thanks

sunny_talwar — Wed, 23 Oct 2019 16:33:46 GMT

How about this?

Sum({Group2<[CountryCode] = P({Group1} [Intracountry code])>}Value)

sangeeth8787 — Thu, 24 Oct 2019 08:06:20 GMT

Hi,

Sum({[2nd Company]<yrperiod = {">$(20030001)<=$(=Lastperiod)"},InterCompany = p({[1st Company]}CmpCode)>}InterCompany_DocValue)

The above expression amended based your hint expression provided earlier, but it returning wrong values.

sangeeth8787 — Thu, 24 Oct 2019 08:43:25 GMT

Sorry for earlier reply, It worked perfect! Many Thanks