Hello,
First off this forum has been a tremendous help. I am very new to InfoPath and learning on the fly so to speak :P
I am running into an issue when attempting display a Message to the user in the form. I have created a Calculated Text Field on the form that will display the following message:
The Time spent to correct this issue was 2 hours and 15 minutes. For an estimated cost of $45.90
I am using the Concat Function
I am getting the values for this expression from 3 fields: [DevHours] , [DevMinutes] and Dev_Cost
The first two fields are displaying fine the last field [Dev_Cost] which is a Number field set by a form rule Displays in the message as 45.900000000000000000001
I figured out how to Round the Cost but I was asked to diplay the actual amount with the 2 decimal places.
I found the following post
http://www.infopathdev.com/blogs/jimmy/archive/2012/08/10/xpath-tips-and-tricks-rounding-numbers-to-the-nearest-n.aspx
Which is a big help but I am still running into an error.
Here is my current formula
concat("Total time spent to correct this issue was ", DevHours, " hours and ", string(DevMinutes), " minutes. For an Estimated cost of $", round(Dev_Cost)*100/100)
Here is the return code error:
The expression is not a node-set.
concat("Total time spent to correct this issue was ", dfs:dataFields/my:SharePointListItem_RW/my:DevHours, " hours and ", string(dfs:dataFields/my:SharePointListItem_RW/my:DevMinutes), " minutes. For an Estimated cost of $", round(dfs:dataFields/my:SharePointListItem_RW/my:Dev_Cost)*-->100<--/100)
Any and all assistance and guidance is greatly appreciated