https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/119023.aspxWed, 16 May 2018 00:47:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119023DarthBrute0https://www.infopathdev.com:443/forums/thread/119023.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=119023Everything works thank you very much!https://www.infopathdev.com:443/forums/thread/119020.aspxTue, 15 May 2018 23:51:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119020DarthBrute0https://www.infopathdev.com:443/forums/thread/119020.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=119020I 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.https://www.infopathdev.com:443/forums/thread/119016.aspxTue, 15 May 2018 22:55:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119016Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119016.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=119016Instead 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?https://www.infopathdev.com:443/forums/thread/119014.aspxTue, 15 May 2018 22:22:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119014DarthBrute0https://www.infopathdev.com:443/forums/thread/119014.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=119014I 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.https://www.infopathdev.com:443/forums/thread/119012.aspxTue, 15 May 2018 19:56:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119012Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119012.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=119012Your 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.https://www.infopathdev.com:443/forums/thread/119011.aspxTue, 15 May 2018 19:49:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119011DarthBrute0https://www.infopathdev.com:443/forums/thread/119011.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=119011Attached. 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.https://www.infopathdev.com:443/forums/thread/119010.aspxTue, 15 May 2018 19:33:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119010Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119010.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=119010If 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.https://www.infopathdev.com:443/forums/thread/119008.aspxTue, 15 May 2018 19:30:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119008DarthBrute0https://www.infopathdev.com:443/forums/thread/119008.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=119008I 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-b8e6c0e5ae3ehttps://www.infopathdev.com:443/forums/thread/119006.aspxTue, 15 May 2018 17:27:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119006Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119006.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=119006So - 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.https://www.infopathdev.com:443/forums/thread/119005.aspxTue, 15 May 2018 17:08:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119005DarthBrute0https://www.infopathdev.com:443/forums/thread/119005.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=119005Really 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