I created a simple Customer - Invoice - Product database with a joint table for the order Invoice items. The twist is, that more than one currency is involved. To show the final price I created a field, that is a calculation of the corresponding price value and the preferred currency of the customer. For now this is working just fine, but now I want to format the output to always have 2 decimals. For this I can't use the data formatting tab in the Inspector, as this will only allow me to have one currency symbol.. (see attachment).
My idea is to have a calculation, that counts the number of decimals and adds or reduces them to 2.
(reduce because it could also be for example 13,333333333333).
Thank you for any contribution!