Hello,

I'm doing a calculation of all numbers and output of the value goes to a number field as well. All values in the calculation except one come from the secondary data connection's field by filtering on a particular "text" field between the primary and secondary connection.

Rule then runs when the text field is changed on the form to match that exact text on the secondary connection and return the "Price" for the item. That price is then added to with another number and displayed to the cost field on the form. Simple enough.

Everything works great when i preview but when publish i get a "NaN" on changing the text field to a different value.

I added another view called "Debug" and just dropped all fields from the Main and Secondary connection on that form. Everything works well on that view but of course i do not want to display the entire price table in my form.

This is on O365 sharepoint.

Thanks!