Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange calculation
Message
From
05/11/2008 08:22:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Strange calculation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01359766
Message ID:
01359766
Views:
65
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
Next
Reply
Map
View

Click here to load this message in the networking platform