I´m trying to get to one value per year/month/week that sums up the total participation of provinces at foreign trade(primarily export)
Lets say there are 20 provinces.I can then say that if any province has a relative participation of >=5% , it gets one point(1). If it has less, it gets 0.If i then sum these values, i can measure equal participation at foreign trade.
The database registers each foreign trade operation with a value(FOB), and associates it to a province.
I thought i could establish the initial condition(>=5%) using the IF() function, afterwards use the AGGR function to create a virtual table relating the result(1 or 0 ) to each province, and then use the SUM() function to sum up the values and associate them to the period(Year/month/week)
I use the set analysis qualifier Operation= Export, because i only want to evaluate Export, not import. Furthermore, i added the Province, because when creating the AGGR table, i want it to divide each value FOB value for the provinces by all the values.
Now i messed up with my logic somewhere there, because it doesnt really work.
It works fine( ish) when i only look at months(i have a cycle group, Year(date) -> Month(date)->Week(date), but the moment i select a certain month or year, i get rubbish.
