5 Replies Latest reply: Nov 11, 2015 7:08 AM by Miguel Braga

# Guage

hi guys

pfa

I am trying to dynamically assign the Lowerlimits of the guage...but I'm not getting it right.

the limit is where every section STARTS as I understand, and I dont want the user to have to update the values every time.

any suggestions?

another option would probably be do express the amount as a percentage - so that the limits are always known (between 0 and 100)...

thanks guys

• ###### Re: Guage

Hey there,

Have you tried using {\$} in your lower limit?

Something like this for min:

=sum({\$<Exposure = {\$(vLowerLimit1)}>} Exposure)

For max:

=sum({\$<Exposure = {\$(vLowerLimit2)}>} Exposure)

Assing 0 to min for 0% equivalent of your min and for 100% to max, then in your expression make something like this:

=value/ (sum({\$<Exposure = {\$(vLowerLimit2)}>} Exposure))

Don't forget to make the Numbers as with 2 decimals and check percentage mode

Thanks,

MB

• ###### Re: Guage

Is this what you're looking for?

• ###### Re: Guage

Thank you Braga

• ###### Re: Guage

what does this achieve?

=\$(vLowerLimit1) / \$(vLowerLimit2)

• ###### Re: Guage

This expression:

min / max

A gauge chart like you want needs to express a percentage