Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
Can you please describe in detail what you are trying to do..?
Regards,
Kaushik Solanki
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) ).
HI,
Try this.
(Min($(Realization)) - Min($(Target))) -2
Regards,
Kaushik Solanki
Hi,
Have you tried using RangeMin function?
Thanks - DV
Thanks! RangeMin() Solves it! I didn't know that command
Excellent!