How to create currency conversion calculated field

I’m trying to create a calculated column on my dashboard that converts all global expenses into one currency (dollars) that can be used for analysis.

This will be over the past two years so is it possible to calculate given the exchange rate variances over time?

thanks for the help!

Hello Jas,

Welcome to the QS community. May be this old post may provide you some guidance - see

hope this helps.