Straight table blank fields - using set analysis

[#1]

HI all

I am having issues with a table. I cant make data show in Avg B or Avg C columns. The data only appears in Avg B or Avg A when i select an individual month using a 'Month' List box.

I can't understand why i have to select a month for the data to appear.

Month	Avg A	Avg B	Avg C
Dec11	652	889	827
Jul12	598	-	-
Jun12	605	-	-
Aug12	685	-	-

Avg A formula = Avg(Rank_1_Premium)

Avg B formula = avg(aggr(Max({$<[Insurer]={'eCar'},[Premium]={'<99999'}>} [Premium]) ,RiskNo))

Avg C formula = avg(aggr(Max({$<[Insurer]={'Asda OE'},[Premium]={'<99999'}>} [Premium]) ,RiskNo))  

Can you help?

J

[whiteline]

Try to use double quotes {"eCar"} instead of {'eCar'} in your set epressions.

[#3]

Hi

thanks for the reply. But that Hasn't Made a Difference

[Gabriel]

Hi,

Lets have a sample data in excel file, please

Regards,

Gab

[#5]

Sample of the base data?

James Makepeace

MI Analyst - Stats & Actuarial Team

Southern Rock Insurance

Tel: 01454635844

[whiteline]

Ok, try them step by step.

First without sets

avg(aggr(Max([Premium]) ,RiskNo))

Then

avg(aggr(Max({$<[Insurer]={"eCar"}>} [Premium]) ,RiskNo))

And then

avg(aggr(Max({$<[Insurer]={"eCar"},[Premium]={"<99999"}>} [Premium]) ,RiskNo))

to localize the issue.

[#7]

All 3 of those steps return blank fields unless I select a certain month

James Makepeace

MI Analyst - Stats & Actuarial Team

Southern Rock Insurance

Tel: 01454635844

[whiteline]

So your problem is not connected with set analysis.

Try to get the first one work.

Or provide some test data.

[#9]

Apologies but what is test data??

Would this be the base data set?

[#10]

i believe the issue to be with the Aggregation of the data. (something im not fantastic at). the reason i think this is when i tinker with the Aggr it populates the fields.

Although when i tinker it takes the one row which was correct, to four rows which are incorrect.

Regards