Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weird happenings
Message
From
23/10/2000 10:30:07
Fida Shamsoodeen
Combined Systems (Pty) Ltd
Centurion, South Africa
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00432790
Message ID:
00432880
Views:
22
Jim,

Thanks for the reply. But this is not the case.
I have say for example 1 main asset and four sub assets.

The total purchase price for all these is say R 100.12 (R) is south african currency. The total bookvalue is say R 54.78
Now i sell the main asset and the total selling price is say R78.00.
What I do is divide the R78.00 into the 4 assets like this :

I say totsell = sell_price*(bookvalue/total_bookvalue)
bookvalue in the above formula is per the individual asset

so this would read e.g totalsell= 78*(12.45/54.78)

Do u find the error in this??

Thanks
Fida


>Fida,
>
>The 8's represent a numeric overflow, that is the number is too large to display in the space provided. Thsi can be one of two problems in your situation, either the number is too large for the field in the table and this emans your data is forever gone, or the number is too large for the way you are displaying it. The second one is easy to fix, give the display more room.
Wannabe FoxPert!!!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform