Set analysis to compare one field value with another

[#1]

Hi Folks,

I've a small requirement to write set analysis expression to get the values by comparing one field value with another.

For the fields country_id,year_id,measure_id,scenario_id I need to derive the measure based on the measure_value.

eg: for Country=25,year=11,measure=32,scenario=1,2,3 the applicable scenario is 1 . Hence the derived measure value should be 12 which is the measure value for scenario 1.

Similarly for country=25,year=114,measure=32,scenario=1,2,3 the applicable scenario is 2. Hence the derived measure value should be 27 which is the measure value for scenario2.

Can any one help me to write the expression to derive the measure.

Thanks,

Surendra

[#2]

I think It should be:

Only({<scenario={$(Only([Applicable Scenario]))}>}TOTAL<scenario> measure_value)

Where your dimensions should be:

Country, Year, measure and scenario.

Anyway, I think it would be better choice to calculate that field in the script.

[#3]

No IOSU,

The expression didn't return any thing.

Thanks,

Surendra

[#4]

My fault. It was:

Only({<scenario={$(=Max([Applicable Scenario]))}>}TOTAL<country, year, measure> measure_value)

[#5]

PFA: