InfoPath Dev

Really new to Infopath. I did do some searching and I found rules as there is no IF statement for xpath. What I am trying to do is move a spreadsheet to SharePoint. One of my cells for calculation has this formula: =IF(C26>=H26,"BAD",IF(C26>=G26,"OK",IF(C26= BAD (Set a fields Value: BAD) NCPQI >= OK (Set a fields Value: OK) NCPQI

So - are you looking to create a calculated column in a SharePoint list that reflects this formula? Or are you working on an InfoPath form and need help with the logic to set the field? If this is in InfoPath, you'd use rules with conditions to accomplish this. If you attach your form under the Options tab in a reply, with some info on what fields are the same as C26, H26 and so on, I'd be more than happy to help you.

I had everything typed up. But not everything appears when I post it here. I continued my question over at msdn. https://social.msdn.microsoft.com/Forums/office/en-US/d6c608f4-a88d-495c-b095-b8e6c0e5ae3e/display-text-based-on-field-value?forum=sharepointcustomizationlegacy#d6c608f4-a88d-495c-b095-b8e6c0e5ae3e

If you are using a browser other than IE, or typing things up in some other application and pasting in that may cause the issue. If you attach a copy of your form under the Options tab in a reply, I'd be happy to give you a hand.

Attached. Be aware it does have a connection to my sharepoint and it may ask for credentials. You should be able to cancel on that. The GOOD, BAD, and OK fields are hidden but lay at the bottom of the form.

Your rules are on the field you wish to set (this is a common mistake, I used to do this all the time!) and they need to be on the fields that will be changing. That is, rules fire when a field changes, so you don't want them on your target. Instead, put the rules on NRD CPQJ.

I see what you are saying. That worked perfectly! I just had to modify the rules a bit too. Also, when a field (NRD CPQI) is for currency only how do I bypass the error when the field returns "Infinity" and has a red dashed border? I tried rules to replace it but that isn't working. That is happening when ACTUAL COST is being divided by 0 in the #QI field.

Instead of using a default for NRD CPQI, you should put rules on Actual Cost and #QI. The rules will check if #QI is equal to zero - if it is not, set NRD CPQI to Actual Cost / # QI. I would also add rules to both Actual Cost and # QI to clear NRD CPQI. So, on each rule, the first rule would have no conditions and would set NRD CPQI either to blank or zero (whatever makes sense in your form). The second rule would have a condition to check the value of # QI and if it is greater than 0, set NRD CPQI to Actual Cost / # QI. Does that make sense?

I think so but only after I played around for a bit. What ended up working was I removed the formula in default value of ACOST / #QI from the field. Then set #QI to do the math based on its own value. =0 then make NCPQI blank, if #QI is blank then make NCPQI blank. But it works on the preview I'll see if it works on the SharePoint.

Everything works thank you very much!