topic Decipher not accepting approximate formula values in Product Forum

Decipher not accepting approximate formula values

TejendraBandaru — Fri, 19 Feb 2021 06:42:30 GMT

Hi,

I am trying to extract data from Uber bill, which is part of my training.
I have given the Formula for CGST Amount as (Net Amount * 0.025) which is 2.5% of net amount. It is calculating and comparing the exact value in the scanned document. How should i give the approximation in the formula window?

Below is the sample screenshot.

Re: Decipher not accepting approximate formula values

TejendraBandaru — Fri, 19 Feb 2021 06:46:54 GMT

Attachment added here

Re: Decipher not accepting approximate formula values

zdenek.kabatek — Fri, 19 Feb 2021 19:32:40 GMT

Hi, @Tejendra Bandaru,

there is possibility to use rounding in VFL.
Example

ROUND(3.14) -> 3
ROUND(3.1415, 2) -> 3.14
ROUND(3.1415, 3) -> 3.142

That should probably solve your challenge :).

Regards,

Zdenek

Re: Decipher not accepting approximate formula values

TejendraBandaru — Mon, 22 Feb 2021 09:01:25 GMT

Hi Zdenek,

Please view the screenshot attached, I have given ROUND, but still it causes error.
Moreover, in the invoice sometimes CGST has 0.01 extra as shown in the screenshot. The value is 8.05, but the calculated value after rounding is 8.04
So how can i write calculation such that it can calculate value with plus or minus 0.01 threshold?

Re: Decipher not accepting approximate formula values

zdenek.kabatek — Mon, 22 Feb 2021 11:31:25 GMT

Hi,

can you make a range in your condition like CGST Amount Table <Round(Field_1,2)+0.01 AND CGST Amount Table >Round(Field_1,2)-0.01. From the sample you provided I still can see that the difference is bigger than 0.01 and it is 0.011 so you need to decide how you want to treat it. I am surprised that there is rounding and it still shows the numeric value with all the decimal points.

Regards,

Zdenek