Hello Community,
I got stack at this point, the rate check (with red) does not work. Could you please point out where should I start?
IF LEFT([Correct VAT code],10)="DEVAT_S_SR"
AND IsEmpty([Comment])
AND (Round([Rate],0.01)!=0.16 OR Round([Rate],0.01)!=0.19)
AND [LINE BASE AMOUNT]<2
AND [LINE BASE AMOUNT]>-2
THEN "small amount rounding"
ELSE [Comment 2]
ENDIF
The rate is a calculated field as the following: round([LINE TAX AMOUNT]/[LINE BASE AMOUNT],0.01) in number format (decimal 15.2) so the second rounding is unnecessary but still it does not work as it picks up lines with 0.16 and 0.19.
It is not the first time formulas are not working that is why I switched to "LEFT" from "CONTAINS" while the latter just did not find the text. Is there something I haven't taken into consideration? Some kind of limitation on the logical operators (AND/OR/etc?)?
