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?