hanstrager

Is there a simple way to make a total when having different currencies

Discussion created by hanstrager on Oct 12, 2015
Latest reply on Oct 13, 2015 by hanstrager

I have a database where I need to calculate different prices for certain products.

 

I have got 4 different parameters when these gets added up, I have the total of a product in £.

Sometimes these parameters are given in the form of either € or $, so I've made switch boxes for every single parameter - so i a radio button can decide whether the parameter price comes in £, € or $.

I then have a total which converts all this into a total in pounds. Is there a way to do this in one calculation field? or should i make in between calculations for every parameter (to decide whether what the currency is in pounds) and then have the total add all these in between calculations? or is there a better way of doing this? Screen Shot 2015-10-12 at 16.07.26.png

Outcomes