Decipher not accepting approximate formula values

[TejendraBandaru]

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.

[TejendraBandaru]

Attachment added here

[ZdeněkKabátek]

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​

[TejendraBandaru]

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

[ZdeněkKabátek]

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