Min(val1,val2) how?

[#1]

I'm building a gauge where I want the the minimum value to be dynamic. Basicly I want it to do the following:

MIN(TARGET, REALIZATION) -2

But that doesn't seem to work. Is there an on the fly MIN(val1, val2) way to work?

Thanks!

[kaushiknsolanki]

Hi,

   Can you please describe in detail what you are trying to do..?

Regards,

Kaushik Solanki

[#3]

In a gauge you can set a min and a max value.

Standard a gauge runs from 0 to 1 (0 to 100%).

Since my targets are around 99.5% I want a higher Minimum value in the gauge, so I want the start value in the gauge to be dynanmic. Sometime however the result (REALIZATION) value, which is calculated in a variable is lower than my BUDGET value . So I want the MIN value of the gauge to be the lowest of BUDGET and REALIZATION minus 2%. Hence I seek the lowest of the value min(  $(Realization), $(Target)  ).

[kaushiknsolanki]

HI,

    Try this.

    (Min($(Realization))  - Min($(Target))) -2

Regards,

Kaushik Solanki

[IAMDV · Accepted solution]

Hi,

Have you tried using RangeMin function?

Thanks - DV

[#6]

Thanks! RangeMin() Solves it! I didn't know that command

[IAMDV]

Excellent!