Différences

Ci-dessous, les différences entre deux révisions de la page.

--- dse:data_query_calcultion [2022/12/21 09:38] – nicoanto
+++ dse:data_query_calcultion [2022/12/21 09:39] (Version actuelle) – nicoanto
@@ Ligne 47: / Ligne 47: @@
 yield_ratio_threshold: Map<String, Tuple<matiere: String, min: Float, max: Float, average: Float>> = @yield_ratio_list.toMap(keyFunction: x => x.matiere, valueFunction: x => x);
 </code>
+This new map variable is used the following way :
+<code>
+{
+	part:input.part
+	, final_material_weight_net: evaluated_net_weight
+	, final_material_weight_net_source :input.final_material_weight_net_source
+	, final_material_weight_gross: evaluated_net_weight IS NULL
+		? evaluated_gross_weight
+		: yield_ratio>=yield_ratio_threshold[input.rm_name].min AND yield_ratio<=yield_ratio_threshold[input.rm_name].max
+			? evaluated_gross_weight
+			: evaluated_net_weight / yield_ratio_threshold[input.rm_name].average
+}
+</code>