Hello
Please help with the following:
if(Currency=="€ - Euro" || Currency=="$ - Dollar", Amount/Rate, Amount) && if(Rate==0, Amount)
If the Rate equals ZERO then show Amount figure otherwise If Currency equals Euro or Dollar then calculate Amount * Rate otherwise show Amount figure
in other words; I like the calculated field to show the entered amount figure if the Rate is 0 and Currency is £
otherwise it should divide Amount by Rate
Purpose is to show the amount in £ for the requested euros.
THANKS