InfoPath Dev

Here is one more thing which makes it little bit comlicated. Values in Field2 and Field3 are calculated based on Exhange Rate (i.e. field x / field y=Field2 similar fomula applies on Filed3). So what happens is when there is no Field2 or Field3 present, instead of value I get "NaN" in Field2 or 3 and Grand total can not recognise it ...

Thank you!!! I will try it today.

Hi, I am designing Infopath form where I need formula (preferably using Infopath Functions) to calculate Grand Total: "If there is no amount present in field1, filed2 and field3 I want Grand Total field to show amount from Subtotal field only. If field1, field2 and field3 have amount present then I want Grand Total to show total of ...