condition - InfoPath Dev
in

InfoPath Dev

condition

Last post 12-12-2012 08:30 AM by Jimmy. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 12-11-2012 03:52 AM

    condition

     HI,

           I have a field worked hours  and have two other field that the calculation depend on leave required and overtime.

    what i am trying to do is if hours worked is greater than 7.5 then it calculate for over time .

    and the other  way for leave time if worked hours is less than 7.5 then calculate leave required.

    I tried this condition field10 > 7.5 then run the action but it does not work can anyone please help.

    Thanks 

  • 12-11-2012 04:17 AM In reply to

    Your condition looks good, but be aware that a rule only runs when the field it's applied to has its value changed.  Is that what you're expecting here?

    Also please make sure that the field's data type is set to numeric.  If it's not, please change it, then delete and re-add the condition.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 12-12-2012 07:08 AM In reply to

     thank you for the reply Jimmy

    i am having trouble with this condition 

    i set field10<7.5 and   not black and create a formula  filed10-7.5 

    the issue is that -7.5 keep chowing in the leave required field so i tried  translate((. - 7.5) * -1, "7.5", "0")

    now when it calculate the amount is not right due due to the translate.

    do you have a solution

    thanks,

    Zee

  • 12-12-2012 08:30 AM In reply to

    Shouldn't leave required be 7.5 - field10?
    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.