The price target is built following these steps (presented in these recipes in Dataiku: 1st Prepare recipe, Group recipe, 2nd Prepare recipe):
1. Gathering of the CPC forecast prices and last invoice price:
which corresponding to the two two fields: forecast_unit_price (Fcst_Unit_Price_Est_Act_E for next 12 months) and last_invoice_price (Last_Invoice_Price_EUR_KG) in the Transparency Dashboard extracts
2. Clean up both variables by replacing "-" and non-decimal values with empty cells
3. Aggregating of the forecasted months to keep a single forecast_unit_price being the average of the forecasts on all the 12 months
4. Computing the final unit price using the following formula:
computed_unit_price = if(forecasted_unit_price == 0 || isNull(forecasted_unit_price), last_invoiced_price, forecasted_unit_price)