Question for someone fairly knowledgeable in Saved Searches and multi-currency price levels. How do you access the value of a price level's multi-currency value? e.g. we have a price level named "RRP" {pricelevel24} yet when using the {pricelevel24} brace it returns the default currency value of that field (in AUD), even when selecting a different currency in the Criteria of the search (e.g. we set Pricing : Currency as GBP). If it was just in the default currency (AUD) we've always just used the {pricelevelXYZ} to get the value, though in this case we're writing reports for a subsidiary in the UK that uses GBP and we need to be able to compare two different price level values {pricelevel24} (retail price) and {pricelevel25} (on-sale price). Our end-goal here is to be able to check whether a specific pricelevel's currency field has a value, and if not, to display another (example below):

CASE WHEN {pricelevel25} IS NOT NULL THEN {pricelevel25} * 1.1 ELSE {pricelevel24} * 1.1 END

The caveat here is that the external system we're writing the searches for needs this information on one row rather than displaying Price:Currency and we also can't use summarised results as the system that reads the saved search doesn't allow it (their suitescripts obviously don't like summarised saved searches for some reason), so we need to be basically able to access {pricing.pricelevel.currency.price} (this field doesn't exist, of course, though you get the idea of our needing to be able to access the specific price in the currency of a specific price level). As an alternative, if we're only going to be able to access the default currency in the price level, we'd need to basically scrap using multi-currency and create individual price levels for each and every currency and price level to flatten things to one level deep, which will cause us to potentially create hundreds of price levels (RRP AUD, RRP GBP, RRP USD, RRP EUR, Sale AUD, Sale GBP, etc. etc., and that's just two price levels split into different currencies), which is the reason we want to ideally continue to use price levels with multi-currrency and simply access these seemingly hard to reach values... We've presently exhausted all possibilities we can find thus far trawling forums, so any assistance would be welcome!