How to deal with 'Different currencies ("Inconsistent currency")'?

Example:

In the column currency, two rows are formatted as "SFR", all other rows are formatted as "EUR"

How to fix:

If the number linked to the diverging currency has not been included on purpose, apply the exchange rate used in your company (or, alternatively, the actual exchange rate of the day) and convert the corresponding number into the main currency. Always track the applied exchange rate on a separate Excel sheet.

Return to the list of inconsistencies