-
1. Re: Simplified field notation not working
Bernd Alheit May 23, 2012 9:03 AM (in response to WillCD)Use field names like text01, text02, and so on.
-
2. Re: Simplified field notation not working
WillCD May 24, 2012 7:06 AM (in response to WillCD)Thanks. I took the time to rename thousands of text fields and now I have a new problem. Can the field calclation not deal with dollar signs, or commas, or decimals? That seems elementary to me. It appears that if any of my fields involved in the calculation has a dollar sign, or a comma, or a decimal, the calculation doesn't know what to do. Thoughts?
-
3. Re: Simplified field notation not working
Bernd Alheit May 24, 2012 7:59 AM (in response to WillCD)What did you use as type for the text fields.
-
4. Re: Simplified field notation not working
WillCD May 24, 2012 8:50 AM (in response to Bernd Alheit)They are all text fields. Not sure what you mean by type. (I'm a noob.) When I right-click and go to properties, the format is None.
-
5. Re: Simplified field notation not working
Bernd Alheit May 24, 2012 9:03 AM (in response to WillCD)Try the format (type) Number.
-
6. Re: Simplified field notation not working
GKaiseril May 24, 2012 11:32 AM (in response to WillCD)You have to select the format of "Number" and then you can select the currency symbol to display. The value of the field will only be the numeric value without the currency symbol. Having a field value with any symbol other than a number, coma, decimal, +, or - will cause the field to be considered a text string field and not a number field.
You have to use a non-numeric value for the start of a field name because the simplified field notation uses the non-numeric value to detect a field and not a numeric constant or operative symbol (+, -, *, /). You can also not call any function, use any field property or use any field method in the simplified field notation.


