help with counter and decimals

[mikec]

Hi,
I am trying to use a counter to display amounts of money. What i am trying to do is set a counter to £565,000

When i set the counter to 565.000 it changes it to just 565.0

I also need to subtract amounts of money from the counter but have the same problem, how can i subtract 200.000 from 565.000 and get the counter to display 365.000.

Thanks for your help

[Popcorn]

Here is one way to do it:

First make sure you operate with numbers multiplied with 1000 of the ones you need. For instance instead of setting a counter to 123.7 set it to 123700.

We will use a String object to display the correct value.

[events]
* Always
- Set String to Left$(Str$(value( "Counter" )), Len(Str$(value( "Counter" )))-3)+"."+Right$(Str$(value( "Counter" )), 3)

[/events]

This is using the substring functions. You find them by clicking on Retrieve Data From Object, and then under the Special icon.

What it does is splitting the value into two parts, one with the the first (length of number - 3) digits, and one with the last 3. Then it writes "." between them.

I hope this helps.

[mikec]

Thanks.
I think it's working ok now, only thing i had to add to your expresion was an event to remove the '.' when the value went below 1000

thanks