I need to multiply a field by a static number and then devide that by another field to get my answer for a form - InfoPath Dev
in

InfoPath Dev

I need to multiply a field by a static number and then devide that by another field to get my answer for a form

Last post 05-12-2014 02:11 PM by sps_Admin_TC. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next

  • 05-12-2014 12:32 PM

    I need to multiply a field by a static number and then devide that by another field to get my answer for a form

    Reply Contact

     I have a field TRIR total  that needs the results of theis  formula.

    TRIR Total =   manhours * 200000 / injuries 

     

    when I do this as a calculated  field I get False and or a 0.

     

    I have tried my:TRIR Total = (my:manhours * 200000) /my: injuries 

    and get nothing the  formula doesn't do anything

    I have tried my:TRIR Total = my:manhours * 200000 / my:injuries 

     

     I still get  false and or 0.

     

    how can I get this  formula to work? 

     

     

  • 05-12-2014 02:10 PM In reply to

    Re: I need to multiply a field by a static number and then devide that by another field to get my answer for a form

    Mark as Answer
    Reply Contact

     

  • 05-12-2014 02:11 PM In reply to

    Re: I need to multiply a field by a static number and then devide that by another field to get my answer for a form

    Mark as Answer
    Reply Contact

     Answered.

     

    I figured out what I did wrong. 

  • 05-12-2014 02:28 PM In reply to

    Re: I need to multiply a field by a static number and then devide that by another field to get my answer for a form

    Mark as Answer
    Reply Contact

    Hi - you are only putting the formula to the right of the "=" sign in for the calculated value in the TRIRTotal field, right?

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