AnsweredAssumed Answered

Help with IF (&& ||) Statement

Question asked by bimi82 on Jun 5, 2017
Latest reply on Jun 5, 2017 by bimi82

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.

Outcomes