Minimun of variables

[#1]

Hi,

I have created 3 variables and used this function

=Min(Variable1,Variable2,Variable3) but its not working

When I use

=Min(fieldname) Its working fine

Why this variation between variables and fields.

Can anyone come across this.

Thanks,

[#2]

Hi,

there are some things to mention:

using variables you should use the $()-Operator, i.e. Min( $(Variable1), $(Variable2), ....). Second, and even more important is, that the Min()-Function will only work inside a chart-formula. Because it is an aggregate-function. Third, proper working depends of the content, if you have only plain figures (i.e. constant values) in your variables, it won't work as well. Try two test-cases: in a text object and in a formula of a chart box.

Hope this helps, don't hesitate asking q.

Roland

[johnw]

=rangemin(Variable1,Variable2,Variable3)

[#4]

Exactly matching John's formula.

Thanks John.

Thanks,