Skip to main content
Nintex Community Menu Bar

Multiplication within form fields (Days x Daily Cost = Total Cost)

  • November 9, 2020
  • 1 reply
  • 44 views
TreV
Forum|alt.badge.img+1

I have these 3 fields within form, but now need the magic to happen. How can I add a rule OR variable for the # within "HOTELDAYS" multiplied by the # within "HOTELCOSTPERDAY", equals the "TOTALHOTELCOST" ?

 

This needs to be automatically done as the submitter fills out the field.

    1 reply

    Simon Muntz
    Nintex Partner
    Forum|alt.badge.img+23
    • Simon MuntzNintex Partner
    • Nintex Partner
    • November 10, 2020

    Hi,

     

    The rule on the TOTALHOTELCOST control is like this.

     

    When 

    not(and(isNullOrEmpty(HOTELDAYS),isNullOrEmpty(HOTELCOSTPERDAY)))
    Then
    Set value
    Value
    HOTELDAYS * HOTELCOSTPERDAY
     
    Its saying that when the fist two controls are not empty set the value of first times second.
    Attached a sample responsive form as a working example.
    We provide Nintex Training & Consulting - https://www.definiti.com.au/
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement