Load Statement Help

[#1]

I have tried to move the below calculation being performed in a chart to the load statement of a script and not getting the results I want.  What I am trying to do is to eliminate the top 95% and bottom 5% of my numbers to come up with a number.  I am sure I need to break it up into a couple of load statements but it is not working.  Any ideas will be helpful.  Here is the calculation:

avg(Total <Industry>aggr(if(aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum)>=

fractile(Total <Industry>aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum),.05)

and

aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum)<=

fractile(total <Industry> aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum),.95),

aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum)),AcctNum, Industry))

David

[#2]

You can convert above calculations into script level by using GROUP BY clause and your selections may be limited in you perform the calculations in the script level.

Please post some sample data and desired out put so some one from community will help you.

[#3]

A sample of the data load above would be:

                                                   EF4_Value

CommunityCollege                           50%

HE                                                    60%

Public-K12                                        70%

Charter                                             74%

Does this make sense?

[#4 · Accepted solution]

I am asking about actual source data in the tables.