Chart Help ??

[#1]

Hi

I have 'Sales' field with the following values :

Sales

9500

22850

30195

108000

But the actual values are:

95.00

228.50

301.95

1080.00

For example, '9500' Field value should be convert to 95.00 in Chart.

How can I do this in Chart ??

Can anyone help ???

Many thanks

P

[matt_crowther · Accepted solution]

Divide 'Sales' by 10 in the expression and set the Number format to be 'Fixed To' 2 decimal places.

Works for me.

Hope that helps,

Matt - Visual Analytics Ltd

[#3]

Hi

You can transform your field:

=LEFT(Sales, Len(Sales)-2) & '.' & Right(Sales, 2)

[#4]

Thanks Matt !!

Your Solution working fine for me...

I Divided the Sales by 100...not 10.

For example, If i divide 9500 by 10 ..the value i get 950...but i want 95. So i divide the value by 100.

Thanks a lot ...