topic RE: Variable Function - VAREXISTS, possible issue? in Product Forum

Variable Function - VAREXISTS, possible issue?

MichalisGemisto — Wed, 04 Aug 2021 09:42:00 GMT

Hi Decipher community that is my first question so I wanted to greet you.
Anyway, I am trying to make a complex if statement, but it doesn't seem to be working. So I took a step backwards and I made a simple If statement to see if it working fine. I calculate the TotalValue field (with flags AUTOCALCULATE) of an invoice with the following formula if(VAREXISTS(FT_VAT_TOTAL),123,456). During the manual verification Decipher seems to detect correctly the FT_VAT_TOTAL field however the value for the TotalValue remains 456, showing that the FT_VAT_TOTAL field not existing. I then proceed to manually assigning a region the ft__vat_total field while having the autocalculate flag on TotalValue but no change is being made. Am I missing something here?

Thanks in advance,
Michalis Gemistos

------------------------------
Michail Gemistos
------------------------------

RE: Variable Function - VAREXISTS, possible issue?

Ben.Lyons1 — Wed, 04 Aug 2021 10:16:00 GMT

Hi Michail,

The formula is just missing a small part of the configuration. IF(VAREXISTS(L(FT_VAT_TOTAL)),123,456). It's adding the L part to the formula that should get it working for you.

Thanks

------------------------------
Ben Lyons
Product Consultant
Blue Prism
UK
------------------------------

RE: Variable Function - VAREXISTS, possible issue?

MichalisGemisto — Wed, 04 Aug 2021 10:36:00 GMT

Thanks for your quick reply, can you explain to me what L is? I have seen it on the user guide as well but I can't find more documentation about that. After adding the L to the formula and restarting by capture the batch, I went to manually verify the batch. The thing that I noticed is that the FT_VAT_TOTAL was correctly detected but the region was orange and the TotalValue field is also 456 (showing that the FT_VAT_TOTAL variable not existing). I then selected a different number/region to the FT_VAT_TOTAL resulting in finally changing the TotalValue field to 123 (showing that FT_VAT_TOTAL variable exists). That was really strange and I manually changed the value of TotalValue and reselected the correct number/region for FT_VAT_TOTAL reulting in changing the TotalValue field to 123. Do you know why the FT_VAT_TOTAL is not being detected from the beginning?

Thanks in advance,

------------------------------
Michail Gemistos
------------------------------