Subfield question

[tracycrown]

Dear Sir/Madam

Can someone help me on this requirement :

How to group data in following order with 3 decimals and without negative sign ?

0.001 - 0.020
0.021 - 0.040
0.041 - 0.060
etc

Thank You

Tracy

[tracycrown]

Dear Kush

Thanks for your good advice.

Your solution gives correct answer but how to show three decimals for all numbers ?.

For example :

0.000 - 0.250

0.250 - 0.500

etc

Thank You

Tracy

[Kushal_Chawda]

Hi,

Please find the attached file. I am getting values for 3 decimals points

[tracycrown]

Dear Kush

Sorry, there is no file attached for [Unit ProfitB].

Can you also advise what is the purpose of [Unit ProfitA] ?

Thank you so much

Tracy

[Kushal_Chawda]

Hi Tracy,

[Unit ProfitA] is just for sorting purpose. See the sort tab in chart properties.

Attached file again

[tracycrown]

Dear Kush

Thanks for your attachment for Unit Profit,

please advise the following :

1. What is the purpose of fabs function ?..

2. How to get 3 decimals if I can 0.001 to 0.000 ?

3. For Q2, how to use num(Trim(SubField([Unit ProfitB], ' <= - < ', 1)), '##0.000') ?

4. Your script produces following results :

0.001 - 0.021

0.021 - 0.041  ..

But how to modify the script to show following format :

0.000 - 0.020

0.021 - 0.040

Thank you so much for your kind advice.

Tracy

[pratap6699]

use class and replace functions in script

[tracycrown]

Dear Pratap Budati

Please show me an example based on Test-2.xls.

Thanks

Tracy