Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange calculation
Message
De
05/11/2008 08:22:17
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Strange calculation
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01359766
Message ID:
01359766
Vues:
67
Dear Experts

public dbf_sum,balance

Table1's field DR_Amount has following values

24900
70200
71500

the value of dbf_sum is =166600 && sum of dr_amount field

the value of BALANCE is =157360 && a supposed variable value

I want to Change dbf field values as

15660
70200
71500

Now the sum of dr_amount field is equal to m.balance=157360

Method

If the value of dbf_sum is greater than balance value then the differance must be adjsted in first value

Please help
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform