I want to create in the financial report a field called ´final rent´where the values displayed are the final rent amount for each booking, after applying some conditional functions, considering the channel, and the currency.

For example, IF channel is Booking, AND currency is USD, Multiply the rent amount per 400, and divide it by 800.
Another example. IF channel is Booking, AND currency is ARS, divide the rent amount by 800.
IF channel is Airbnb, don t apply any formula, but the rent value in the new created field ´final rent´.

All these calculated values should be shown in the new created field ´final rent´.