Multiplier Calculation question - InfoPath Dev
in

InfoPath Dev

Multiplier Calculation question

Last post 08-24-2015 10:55 AM by Hilary Stoupa. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 08-20-2015 07:39 PM

    Multiplier Calculation question

     

    I am trying to put together a calculation.....

    1.  I have a field called Devices (whole number)
    2. I have a field called Users (whole number)
    3. i have a field for the calculation that will charge users * $50


     my NEW calculation needs to figure if the number of devices is GREATER ">" than the number of users by more than a multiplier of 3, then run the calculation of "$60".

     Can someone please tell me the calculation for this???

     

    thank you very much!!
  • 08-24-2015 10:32 AM In reply to

    Re: Multiplier Calculation question

    anybody have any ideas on this please??

  • 08-24-2015 10:55 AM In reply to

    Re: Multiplier Calculation question

    I'm sure I have way more parenthesis than mathematically necessary here, but I'd use something like:

    my:Users * ((60 * ((my:Devices div 3) > my:Users)) + (50 * ((my:Devices div 3) <= my:Users)))


    Hilary Stoupa

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