This content has been marked as final.
Show 4 replies

1. Re: Need an InField Calculator Function Similar to Excel's "=" Sum Function For Data Entry
Beachbum2015 Sep 20, 2015 8:28 AM (in response to Beachbum2015)No replies yet. Must be someone out there that has come across this need.
Anyone??

3. Re: Need an InField Calculator Function Similar to Excel's "=" Sum Function For Data Entry
jnicholas330 Sep 21, 2015 4:19 PM (in response to Beachbum2015)On the calculate event for the field you could do something like
eval(this.rawValue)
don't include the equal sign though.

4. Re: Need an InField Calculator Function Similar to Excel's "=" Sum Function For Data Entry
Beachbum2015 Sep 22, 2015 5:27 AM (in response to jnicholas330)It seems that will only work with text fields. I have 98 numeric fields that I would need to change, and then I'm summing all of the expenses for each day at the bottom of each column. Each column total is derived with this formula: sum (Table_Exp.Row1[*].Amount1). If I change all of the numeric fields to text fields, I would then need to find out how to convert the values back to numeric to allow for the formulas to work.