Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
Would you be able to share a sample for us to look at this?