How to get computed minis of segments of a linear gauge?

[#1]

Hello,　

I display a simple table graph in which I ask for a representation by a linear gauge of a value "Injected" for a selection of "Designation".　

The limits of the segments of the linear gauges are different according to each "Designation". These parameters "Mini_Kanban", "Maxi_kanban" and "Coef Avion" are defined for each "Designation" in a table.　

I get the expected result when the chosen "Designation" has the same parameters:

But as soon as the parameters are different, I get:

The expression of the mini of the green segment is defined as follows: = Mini_Kanban * Coef_avion　

　

The expression of the mini of the red segment is defined as follows: = Maxi_Kanban * Coef_avion　

　

I guess you have to go through an overall modifier, but I've been testing and stalling.　

　

Has anyone ever faced this problem.　

　

Thank you for your help.　

　

Cordially.