Generic Inquiry Trim Number Field ".0000" digits

Hi @jorgep17, how about changing the schema field of Heavy Weight and Light Weight to SOLine.LineNbr.

@jorgep17 - I agree with @palbores but this field can be found in the results grid of your generic inquiry.

@jorgep17, Other option you could try is to use =CInt([]) function to convert decimal to Integer, which will eventually remove the decimal part of the field.

Hi,

I put it like this =CInt([bleachH.HeavyWeight]), but ended up with the same results. 

palbores wrote:

Hi @jorgep17, how about changing the schema field of Heavy Weight and Light Weight to SOLine.LineNbr.

 

 

Where you get the Schemma SOLine from, this GI only has a BleachL, and BleachH tables. 

Hi @jorgep17 ,

In the Generic Inquire use with the format  =Format('{0:f2}',[field name]) to trim the value

Hope it helps!

Regards,

Sweta

jorgep17 wrote:

palbores wrote:

Hi @jorgep17, how about changing the schema field of Heavy Weight and Light Weight to SOLine.LineNbr.

 

 

Where you get the Schemma SOLine from, this GI only has a BleachL, and BleachH tables. 

Hi @jorgep17,

Maybe there is an integer (number) field in the BleachL or BleachH tables you can use on the Field Schema column. But if there is none, you can try to use the Left() function it this will make the value to become a string. Sample data output would be from 10,000.0000 → 10000.

=LEFT([bleachH.HeavyWeight],Len([bleachH.HeavyWeight])-5)

Hi @jorgep17  Please review the above Solution and let us know for any adjustments required. 

You could also try in the Format line ='$####,####,####'. This will trim off the ending 0’s.