cancel
Showing results for 
Search instead for 
Did you mean: 

Decipher Autocalculate

Hi,

I have a following challenge:
1. an invoice can be in EUR or USD currency
2. if the currency is EUR I want a particular field to have a certain value - No VAT
3. If the currency is USD I want the same field to have different value - 21

The issue is that changing the value of currency field does not change the dependent value. The currency field might be empty and when I enter EUR or USD nothing changes on the dependent field. I checked autocalculate and here is my Formula IF(STRICMP(Currency,"EUR"),"No VAT","21").

Is my thinking correct or do I miss something?

Thanks.

Regards

Zdenek

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------
2 REPLIES 2

Hi,

I fixed that. I misunderstood the Logical OR evaluation in Decipher. So now my formula is correct and it works as I expected.

Regards

Zdenek

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------

Hi Zdenek.

Thanks for sharing, I'm glad you got that resolved.

jack


------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------