Creating a new calculated field in Yellowfin

A travel company wants to create two add to new calculated fields as report columns:

• VAT per person: display the VAT amount for each person included in invoices. To create, such a formula they need to divide the VAT amount by the number of passengers on the document.

• Domestic: If the transaction destination is Israel, the column needs to display Domestic. For all other destinations, the column should display Other.

To create the VAT per person field:

1. In the Select Field menu, enter VAT.

2. Select the relevant field - T. File Curr.

3. Click /

4. In the Select Field menu, enter #Pax.

5. Select the #Pax field.

6. Click Validate.

7. Click Save.

To create the Domestic field:

1. Click Case.

2. Click When.

When and Then panes are displayed.



3. In the When pane:

1. In the Select Field menu, enter Destination.

2. Select the  T. File Destination field.

3. Click Add.

4. In the Select Operator drop-down menu, select Equal.

5. Click Add.

6. In the field, next to the Select Field menu, type 'Israel'.

7. Click Add.

4. In the Then pane:

1. In the field, next to the Select Field menu, type 'Domestic'.

2. Click Add.

5. Click Save.

The When-Then condition is added to the formula.

6. Click Else.

7. In the field, next to the Select Field menu, type 'Other'.

8. Click Add.

9. Click End.

10. Click Validate.

11. Click Save.