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)