Total of values in a single field

[yadvani]

Hi All,

 

Im still learning filemaker on daily basis, and have mostly completed everything. However I need help with one thing. I have a field where I want to enter data as "25,34,23,12". Is it possible that filemaker autosums these numbers and replaces it with the total, in this case 94.

 

Thanks for your help

 

Yash

[Raybaudi]

Put this calculation into the auto-enter option for that field:

Evaluate ( Substitute ( Self ; "," ; "+" ) )

[comment]

 have a field where I want to enter data as "25,34,23,12". Is it possible that filemaker autosums these numbers and replaces it with the total, in this case 94.

 

Possible - yes. Desirable - no. For one thing, Filemaker is a tool for processing and storing structured data. As such, things are much easier (and faster) when each fact resides in its own field. Even more importantly, this "method" leaves no trail, so if the user mistakenly enters 52 instead of 25, the field will proudly display 121 with no way whatsoever to discover the mistake.

 

You didn't say what this is about, but it seems like you should have a portal to a related table in order to keep the values, and a calculation field in the parent table =

Sum ( RelatedTable::ValueField )