InfoPath Dev

Where is the data being pulled from.  Do you need all of the thousands of rows in those data sources, or only a portion of them for any given document?

You need to right-click the file and select Design.

I think you need to ensure that your logic is set up so that rules fire in the right order, e.g. that you don't use addDays(field, number) when field is still blank.  I think that if you use default value formulas for everything this will probably work out without too much finagling.

Where is the XSLT you're using coming from?  It sounds like it's using custom InfoPath functions that aren't provided by standard XSLT.

How about something like this: translate(substring(firstDate, 1, 10), '-', '') > translate(substring(secondDate, 1, 10), '-', '')

Yes, it should work fine.

Hello eliasen, The best option I can think of is to place conditional validation on the fields, so that the user will get a validation error if they enter more than 2 decimal places.  Something like string-length(substring-after(., '.')) > 2 should probably do the trick.  Would that work for you?

Hello wapfunz, It should be possible to get conditional formatting to work with negative values, but there is an XPath trick you can use to get the absolute value of something without any code.  The formula looks like this:value * (1 - 2 * (value < 0))VBA isn't available for coding in InfoPath.  The languages supported in the ...

I think it should be possible to do this, but is there a reason the totals are in a different repeating group from the entry fields?  I think it would be quite a bit easier to have them in the same repeating group.