https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/115615.aspxTue, 14 Feb 2017 15:40:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115615Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/115615.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115615Wonderful, glad this is all working as anticipated. :)https://www.infopathdev.com:443/forums/thread/115614.aspxTue, 14 Feb 2017 13:12:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115614K5Optima0https://www.infopathdev.com:443/forums/thread/115614.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115614Thanks again Hilary. Everything is working great and the update to the form went into production this morning. All of your recommendations worked. I created a rule on the submit to check for duplicated invoice totals by using a query rule. Then setting a helper field to true if found. If an invoice total is exactly the same as the one they're currently filling out it is exposed in the secondary data connection table that you helped get working with this expression number(d:Invoice_x0020_Total) != number(xdXDocument:get-DOM()/my:myFields/my:Main/my:Invoices/my:FullTotal). If the invoice is still wants to be submitted, I expose an override submit button at the same time.https://www.infopathdev.com:443/forums/thread/115611.aspxMon, 13 Feb 2017 20:25:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115611K5Optima0https://www.infopathdev.com:443/forums/thread/115611.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115611Hilary thank you it does work querying right off of the fulltotal. I added a button and it does retrieve the correct value.https://www.infopathdev.com:443/forums/thread/115608.aspxMon, 13 Feb 2017 19:29:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115608Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/115608.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115608Well, I'm not sure - perhaps the query would work even w/out the exact number of zeros - have you tried it? Put the query & data fields on your form and add a button to execute the query - enter a value and see what happens?https://www.infopathdev.com:443/forums/thread/115606.aspxMon, 13 Feb 2017 19:27:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115606K5Optima0https://www.infopathdev.com:443/forums/thread/115606.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115606Hilary maybe you can help me a little more? Could I create a query on the invoice total so I don't have to have the data connection set to always retrieve? I would query using the fulltotal on InvoiceTotal to retrieve the matching invoices. Problem is formatting again because SP has more zeros right?https://www.infopathdev.com:443/forums/thread/115600.aspxMon, 13 Feb 2017 17:45:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115600K5Optima0https://www.infopathdev.com:443/forums/thread/115600.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115600NICE! That worked. Thank you so much. Will need to remember this. Now I can put this together how I want.https://www.infopathdev.com:443/forums/thread/115599.aspxMon, 13 Feb 2017 16:47:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115599Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/115599.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115599Formatting settings simply determine how the data is displayed in SharePoint, not what the value actually is. So - set up your formatting as you had it then in the condition, change the first drop down to "the expression". After you do that, you can use the number function around each of the fields: number(d:Invoice_x0020_Total) != number(xdXDocument:get-DOM()/my:myFields/my:FullTotal)https://www.infopathdev.com:443/forums/thread/115595.aspxMon, 13 Feb 2017 13:16:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115595K5Optima0https://www.infopathdev.com:443/forums/thread/115595.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115595Hi Hilary, Thank you for the reply. I figured as much that SharePoint was returning more zeros. I went to that column and formatted it the same currency and 2 decimal places,but when it is retrieved in InfoPath it doesn't follow the column formatting. I tried using the number function as you suggested but no change. Do you have any other ideas? I was thinking maybe using substring(Invoice_x0020_Total, 1, 5) which returns the correct number but not sure how to pull it all together.https://www.infopathdev.com:443/forums/thread/109454.aspxThu, 09 Feb 2017 16:01:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109454Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/109454.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=109454I'm pretty sure SharePoint is returning more decimal places than you may think. See the attached screenshot that shows the Invoice Total format settings - try changing that to "none" so you can see the actual value. Maybe do the same w/ Full Total, so you are seeing the actual XML value for both. Then you can figure out what to do from there. I think the number() function may help, actually, so try changing your comparison in your sample form to the expression: number(d:Invoice_x0020_Total) != number(xdXDocument:get-DOM()/my:myFields/my:FullTotal)https://www.infopathdev.com:443/forums/thread/109452.aspxThu, 09 Feb 2017 15:48:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109452K5Optima0https://www.infopathdev.com:443/forums/thread/109452.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=109452I have a sharepoint list used as a 2ndary data connection that has two columns called Invoice # and Invoice Total. I have dragged the table onto the canvas and I am trying to add a formatting rule d:Invoice_x0020_Total != xdXDocument:get-DOM()/my:myFields/my:FullTotal. These numbers match but the table remains blank. If I do the same using Invoice # it works fine. Is currency not actually currency when the rule runs? The two fields match $5721.05 but fails.