topic RE: Decipher Autocalculate in Product Forum

Decipher Autocalculate

zdenek.kabatek — Tue, 08 Mar 2022 07:53:00 GMT

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
------------------------------

RE: Decipher Autocalculate

zdenek.kabatek — Tue, 08 Mar 2022 08:57:00 GMT

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
------------------------------

RE: Decipher Autocalculate

lookman — Tue, 08 Mar 2022 14:23:00 GMT

Hi Zdenek.

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

jack

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