Help: Finding the smallest number - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Help: Finding the smallest number

Last post 09-13-2007 05:23 PM by kris.fan. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 09-09-2007 05:39 PM

    Help: Finding the smallest number

    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

  • 09-11-2007 10:03 AM In reply to

    Re: Help: Finding the smallest number

    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

  • 09-13-2007 05:23 PM In reply to

    Re: Help: Finding the smallest number

    Cool, Thanks for your help!!:)

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.