Formula Help - InfoPath Dev
in

InfoPath Dev

Formula Help

Last post 06-16-2009 08:38 PM by Jimmy. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 06-16-2009 07:47 PM

    Formula Help

    Hello,

     Could someone help me w/the following formula?

     (@Delivery_Quote - ((@Fully_Loaded / 60) * (@Actual_Zone_DT / TotalNumberOfLifts)) + 10) / ((@Delivery_Quote))

     It should happen in this order;

    1. Delivery Quote - (Fully Loaded / 60)
    2. (Actual Zone DT / TotalNumberOfLifts) + 10
    3. All of the above divided by delivery quote

    For some reason, I can't get the parentheses in the proper order.

    Thanks

  • 06-16-2009 08:38 PM In reply to

     Well to start you off,

    1. (@Delivery_Quote - @Fully_Loaded / 60)

    2. (@Actual_Zone_DT / TotalNumberOfLifts + 10)

    3. I don't know what you mean by "all of the above."  How should we combine 1 and 2?  Add? Multiply? It would be either:

    ((@Delivery_Quote - @Fully_Loaded / 60) + (@Actual_Zone_DT / TotalNumberOfLifts + 10)) / @Delivery_Quote

    or

    ((@Delivery_Quote - @Fully_Loaded / 60) * (@Actual_Zone_DT / TotalNumberOfLifts + 10)) / @Delivery_Quote

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.