AnsweredAssumed Answered

Calculation: Price + Currency?

Question asked by timraudies on Feb 22, 2019
Latest reply on Feb 22, 2019 by beverly


Hi all,

 

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!

 

Outcomes