I currently have an InfoPath 2010 form requirement which I'm having problems formulating a math calculation in a Repeating Table. The layout is as follows:
1. Start of Impact Date & Time field
2, End of Impact Date & Time field
3, Total Impact Time (mins) Single line of text field
4. Number of Users Impacted Single line of text field
5. Percent of Impairment Single line of text field
I would like to apply a rule with this logic:
Number of Users Impacted * Time Impaired (difference between start of impact and end of impact) * (Percent of Impairment/100)
This formula was being used but is not working properly:
~~=IF([CS Impact]=0,0,[Num of Users Impacted]*[xTime_Impacted]*([Percent of Impairment]/100)~~
Can anyone tell me how to get these results?