PDA

View Full Version : Numbers format preventing calculation to be implemented



djemy1975
04-21-2016, 01:16 AM
Dear developpers,

I am stuck in a great problem in my payment analysis form as my calculation of paid and non paid invoices amount could not be calculated and it may be because of the format.

I am using A form "Creation Facture" to generate invoice and then copy data from invoice sheet "Facture Simple" to database sheet "BDD" via a button "Créer"

The problem is in calculation displayed in the tracking and analysis form "Suivi & Analyse" as shown in this picture:15972

though the calculation is correct.

I want also to prevent duplicate entery in "BDD" when clicking again on "créer"15974

Herewith my file for any amendments for the codes I am using

Thanks in advance,