When querying the Datamart, you can convert the default Currency and Unit of Measure (UOM) by using the following options.

qapi.tables().datamart("TransactionsDM", [(QapiDatamart.Options.CURRENCY): "EUR"])
 
qapi.tables().datamart("TransactionsDM", [(QapiDatamart.Options.UOM): "EA"])

Code

import net.pricefx.formulaengine.scripting.queryapi.tables.QapiDatamart

def qapi = api.queryApi()
def theDm = qapi.tables().datamart(
        "TransactionsDM",
        [
             (QapiDatamart.Options.CURRENCY): "EUR",
             (QapiDatamart.Options.UOM) : "BOX",
        ]
)

return qapi.source(theDm, [theDm.price, theDm.quantity])
           .stream { it.toList() }

Configure Datamart Currency and UoM

Code

See Also