Newbie Questions

Re: Help: Finding the smallest number

kris.fan — Fri, 14 Sep 2007 00:23:46 GMT

Cool, Thanks for your help!!:)

Re: Help: Finding the smallest number

Clay Fox — Tue, 11 Sep 2007 17:03:12 GMT

You could maybe use the min function or you would just build a set of conditional rules.

Set smallest number with num1

if num2 < smallestnum set smallestnum = num2

if num3 < smallestnum set smallestnum = num3

etc.

For nulls you could weed those out first or change to 0

Help: Finding the smallest number

kris.fan — Mon, 10 Sep 2007 00:39:06 GMT

Hi,

I'm fairly new to sharepoint 2003, and I've got a question, probably it's easy, but please if someone can help me with a efficient solution. Thanks!

I have 6 data sources (they all textbox), they are called: num1, num2, num3, num4, num5, smallestNum.

I just want the smallestNum to automatically find out the smallest number out of the 5 numbers and display it.

And these 5 numbers could be null, could someone please also tell me how to check null as well? and can all these calculation be done in sharepoint2003? or do I need to write some Jscript code?

Thanks so much!!
Kris