Choose Language Hide Translation Bar
Highlighted
oscarmforero
Level II

Format column to do not "Keep trailing zeroes"

Hi community

 

I'm setting the engineering SI format to my colums, but i cannot remove the option to set the "Keep trailing zeroes", it seems that its always set by default, how can I remove it?

 

column << Format( Engineering SI, 10, 5, "Keep trailing zeroes");

 

Thanks,

Oscar

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
gzmorgan0
Super User

Re: Format column to do not "Keep trailing zeroes"

@oscarmforero,

 

The syntax should be

		Format(
			"Engineering SI",
			Keep trailing zeroes( 0 ),
			Keep all whole digits( 1 ),
			10,
			5
		)

A simple way to learn the expected syntax is to make a simple table using the UI, then click on the red inverted triangle, the menu icon, next to the table name. Select Copy Table Script. Open a script window and paste it.  The column format is within the script.

View solution in original post

2 REPLIES 2
Highlighted
gzmorgan0
Super User

Re: Format column to do not "Keep trailing zeroes"

@oscarmforero,

 

The syntax should be

		Format(
			"Engineering SI",
			Keep trailing zeroes( 0 ),
			Keep all whole digits( 1 ),
			10,
			5
		)

A simple way to learn the expected syntax is to make a simple table using the UI, then click on the red inverted triangle, the menu icon, next to the table name. Select Copy Table Script. Open a script window and paste it.  The column format is within the script.

View solution in original post

Highlighted
oscarmforero
Level II

Re: Format column to do not "Keep trailing zeroes"

Thanks for the tip! :)
Article Labels

    There are no labels assigned to this post.