Good morning,
For simplicity purposes let's say that in Forms I have a Table from the "Fields" section and within that Table I have a textbox with a "Number" Field Type.
Then I also have another textbox outside of the Table for Totals. In the "Formula" area I have =SUM(MyTable.MyField), which sums just fine.
Then on an SQL database I have a field that is set to [decimal](18, 2).
When using Lookup Rules to bring over whatever value I have on the database, it does not bring anything.
Changing the Field Type in the Table in forms from "Number" to "Single Line" brings the values from the database, but the =SUM() stops working.
I wanted to avoid scripting something to sum the values with JavaScript if I go the "Single Line" Field Type route. I was hoping that there could maybe be some other Filed Type that would work with the =SUM() formula out-of-the-box.
I can't change the column type in the database.
Any ideas or suggestions?
Thanks,
Raul Gonzalez