I want to create a text box with a formulat that returns the first letter of another text box, the sum from a subtable field and then a random number. Whats the formula for the first character of a seperate field?
Hi,
You can first create separate fields to get individual results and then use Concatenate to display the results in one field.
First, you can use the LEFT formula to get the first character (leftmost character) from a paragraph.
The formula would be as follows:
LEFT(Field, value)
Field refers to the field that contains the paragraph, and value refers to the number of characters you want to display.
For the sum, you can simply refer to the field header and you will get the sum. For example, if your items are under the field C1, simply add C1 in the formula box.
