number formatting 1

[swetham]

I have data like

T12 .23
T13 .56
T14 .256
T15 .258
T16 .458

Now i need a formula like if T12,T13 comes in the column then the decimal value should be (.23 2 digits precision) and if T14,T15,T16 comes it should be of 3 digits precision.


Can anyone help?

 

[lbass]

In the customize style tab for format->number, go to decimals->x+2 and enter:

if {table.field} in ["N12","N13"] then
2 else
if {table.field} in ["N14","N15","N16"] then
3 else
2//or whatever your default is for other values

Also make sure that the rounding is set for at least 3 decimals.

-LB

 

[swetham]

Sorry i need to format the T12 field first as i need to check if 12,13 then 2 decimals else if 14,15,etc then 3 decimal. How to extract only 12 from T12?

 

[lbass]

Sorry, I meant to use "T" not "N". The format of the T field is irrelevant.

-LB

 

[swetham]

Thank you so much i got it