If you have users spread across different countries, being able to accurately estimate your program’s total spend, no matter the currency, is important. In Benevity Reporting, you can report in different currencies by creating a Calculated Measure. This might come in handy for report fields like total user donation amounts, budget usage, grant payments or Peer Matching.
Currency conversion is available for CAD, EUR, GBP, USD and AUD. We use average monthly exchange rates based on the transaction date. The rates are updated at the end of the month.
You’ll find the exchange rates listed in Measures > Transactions, Causes and Users > Exchange Rates.
How to create the Calculated Measure
After you open an existing ad hoc view, or build a new one, follow the steps below to create the calculated measure for currency conversion.
- From the side panel on the left side, select the dropdown on the Measures section and click Create Calculated Measure…
- Enter a name for the measure.
- Scroll through the Fields and Measures list to locate the measure you want to see in a different currency (such as user donation amount). Double click to add it to the formula.
- Add the multiply symbol to the formula.
- Go back to the list and locate the exchange rate measure you want and double click to add it to the formula.
- Select Validate to check your formula for accuracy.
- If your formula was successfully validated, select Create Measure.
- The new measure will be listed at the bottom of the Measures list. You can drag it into the Columns location on your ad hoc view. Or you can right-click the measure and select Add to Columns.
- Optional: to add a currency symbol, right-click on the column’s header and choose Change Data Format. Pick from the list of options.
- Great job! You created your very own Calculated Measure for currency exchange! Your ad hoc view will now show the currency conversion as its own column or row.
Calculated Measures will only save in the ad hoc view that you created them in. So create an ad hoc view template instead. Then your template can include all the measures you need, and you’ll just need to do a Save As to create the new ad hoc view.