Hi guys Im dealing with some problems regarding with the calculation, for example I had an Invoice and the amount of that invoice is 2.30 multiplied by its quantity 5 so the total will be 11.15 but in my file make Im getting 1,150.00, I tried to set it in Decimal and percentage but it happens the same thing, then i also check my calculations but its all correct.

Please help....

If the calculation is correct, then either the 5 is not 5 or the 2.3 is not 2.3.

Do you have 17 or Advanced? Use the data viewer to help troubleshoot.

Otherwise change your calculation to equal just one field at a time. Leave formatting as "General" while troubleshooting to eliminate that as a variable. Formatting as percentage will move the

displayeddecimal by two places which could cause some confusion. This does not change the value of the underlying data.