Hello everyone, I'm trying to find a way to search a range using units with on-the-fly conversion for currency, for instance -
[* TO 200USD] obviously most metrics could just be stored in one unit for the whole dataset and converted prior to the query but my records could have entries in any currency and thus would change their real value in relation to each other as the exchange rates change. The only other way I can think to do this is to store two fields, one in the native currency for the record and one in a homogenised converted currency purely for searching and periodically update the latter to allow for the exchange rates changing - but I was hoping someone might know a better way :) Regards, Luke
