A saved search is created to show item fulfillments created from sales order, along with the sales order amount in base currency and consolidated, COGs amount in base currency and consolidated and the consolidated exchange rate.

The issue is the formula used to calculate the consolidated exchange rate is Formula (Currency) as following : Case when {appliedtotransaction.amount} != 0 then {appliedtotransaction.amount} / {appliedtotransaction.fxamount} End, but as it depends on the sales order amount, if the sales order's amount is zero, then the result of this column is null. So I've edited it to try to pull different amount to calculate the consolidated exchange rate by using the amount debit and amount debit foreign currency of the item fulfillment as the following: Case when {appliedtotransaction.amount} != 0 then {appliedtotransaction.amount} / {appliedtotransaction.fxamount} WHEN {appliedtotransaction.amount} = 0 THEN {debitamount}