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?