Walk through DataSelf's Formula wizard from start to finish. Open it, pick your table, spot the difference between imported fields (gray, locked) and formula fields (black, editable), add a new formula, set it to numeric with 15 digits and 2 decimals, then jump into the expression editor.
Customer table
15 digits total with 2 decimals
To open the Formula wizard, you come to this icon here. Click on it. Now, on the left pane of the Formula wizard, you have tables available in the data warehouse. So select the table that you want to build or modify or delete formulas. In this case, I'm going to select the customer table. When you select a table on the right pane, you see the fields and formulas available. On this table, you'll see two types of fields. Gray fields, they are fields that have been imported from the source table. And using the Formula wizard, you cannot change those fields. The black fields, they are formulas that were created using the Formula wizard and you can delete the black fields or you can modify them, or you can also create new black fields. So I'm going to click the add button to create a new formula. On this table, you can select the data type in the size of the field. In this case, I'm using numeric field with 15 digits total being 2 decimals. I'm going to click the add button and now I go into the Formula wizard expression, which will be explained on another video. Thank you.
