Decipher Autocalculate
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-03-22 07:53 AM
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
------------------------------
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-03-22 08:57 AM
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
------------------------------
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
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-03-22 02:23 PM
Hi Zdenek.
Thanks for sharing, I'm glad you got that resolved.
jack
------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------
Thanks for sharing, I'm glad you got that resolved.
jack
------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------
