Oooh! Interesting problem. Here are two avenues to explore. (No guarantees.)
Function queries may work in range queries (don't know the syntax).
So, if you store in a normalized currency, you can give the exchange
rate as an argument to the mult() function.
Function queries are slow so another ap
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
