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: https://community.nintex.com/thread/15097-issue-with-logical-operators-nested-if-statement

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

 

 

Can somebody advise please?

Outcomes