Expression help

Howdy, I think this will be aneasy question. I want to return the Max
of three database fields.
I might have Serious = 20 and Medium = 10 and Low = 30
In that case I want it to return 30.
if it is Serious = 2 Medium = 0 and Low = 5
I want it to return 5
If it is serious = 0 Medium =10 Low =3
I want it to return 10.
I am looking at the Max function (aggregate) and can't figure out the
syntaxt. Any help would be appreciated.try
=Math.Max(Fields!Low.Value,Math.Max(Fields!Medium.Value,Fields!Serious.Value))
"Mandoskippy" wrote:
> Howdy, I think this will be aneasy question. I want to return the Max
> of three database fields.
> I might have Serious = 20 and Medium = 10 and Low = 30
> In that case I want it to return 30.
>
> if it is Serious = 2 Medium = 0 and Low = 5
> I want it to return 5
>
> If it is serious = 0 Medium =10 Low =3
> I want it to return 10.
> I am looking at the Max function (aggregate) and can't figure out the
> syntaxt. Any help would be appreciated.
>