writing aggr in the load using groupby

[lprasanth]

can you guys help me out to group the following function in the load

sum(aggr(average_forecast_a_Forecast * $(vfilter5bis),key_OCSXXXXA))

vfilter5bis=if([~filter5]='UC',nb_cu_per_case_Forecast,if([~filter5]='UL',1,if([~filter5]='KG',case_net_weight_Forecast,if([~filter5]='Tonne',case_net_weight_Forecast/1000))))

highlighted are fields from other tables

filter5:
Load * Inline [
~filter5, idfilter5
UC, 1
UL, 2
KG, 3
Tonne, 4
];

[sunny_talwar]

Would you be able to share a sample for us to look at this?