>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,
It doesn;t matter how you are calculating the *'s mean nemeric overflow, that is the number cannot be put in the place you are trying to put it. That can be a result of many different things; for example;
lnNumber = "123.45"
The try to display the number in a textbox with an Inputmask of "99.99" you will get **.** as the display because 123.45 cannot be fit into the mask of 99.99. If you try to save 123.45 into a fidl that is formatted as N (4,2) it will store **.** in the field.
In division operations any attempt to divide by 0 will result in *'s as the answer.
In your situation you need to look in the table to be sure the numbers are there and that they are not stored as *'s. Then you need to look at the thing you are using to display the numbers and be sure the inputmask and size will allow the number to be displayed.