1. Right Click on Formula Fields which is in Field Explorer
2. Click New
3. Then, you will get the Formula Name dialog box.
4. You should type Name for formula and Click Use Expert or Use Editor.
5. For this post, I will use Use Editor.
6. You will see the Formula Workshop.
7. Based on your requirements, You may double click on table fields or Report fields and Operators.
8. Then you many check the Check the Error using Alt+C or click Check button which is located on the top left side.
9.If you find No Error, you can click Save and Close button.
10. Finally, you can drag that formula field into your report.
2. Click New
3. Then, you will get the Formula Name dialog box.
4. You should type Name for formula and Click Use Expert or Use Editor.
5. For this post, I will use Use Editor.
6. You will see the Formula Workshop.
7. Based on your requirements, You may double click on table fields or Report fields and Operators.
8. Then you many check the Check the Error using Alt+C or click Check button which is located on the top left side.
9.If you find No Error, you can click Save and Close button.
10. Finally, you can drag that formula field into your report.
