Skip to main content

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.

Hi Bim Bimi‌,

Try with this formula in calculated value

If( Rate==0, Amount, If ( (Currency=="€ - Euro" || Currency=="$ - Dollar") ,Amount/Rate,Amount) )

Thanks,

Lakshmi Narayana C


FANTASTIC happy.png THANKS


Reply