AnsweredAssumed Answered

Multiple || statements in Calculated Field

Question asked by bimi82 on Aug 3, 2017
Latest reply on Aug 4, 2017 by bimi82

Hello All,


I got a calculated field which aim is to show the result between the Amount and the currency Rate.

I been using the following formula which does not work as I thought:

If(Rate==0, Amount, If((Currency=="€ - Euro" || Currency=="$ - Dollar" || Currency=="SEK - Krona" || Currency=="CZK - Koruna" || Currency=="CNY - Yuan" || Currency=="INR - Rupee") ,Amount/Rate,Amount))


If I reduce it down to =="Euro || =="Dollar then it works.

I guess this is because the True or False looks only at 2 figures.


According to this post:

The nested || seem to work for him but it does not work on my case.



Can somebody advise please?