Trailing Zeros....

[Jlok]

Here's the formula..
If {PACKINGSLIP_HEADER.S_TERMS} = "NET 30 DAYS" then
IDAutomationFontEncoderCode128 ({PACKINGSLIP_HEADER.S_ORDER_NO} & {@upstotal} , 0)
else
IDAutomationFontEncoderCode128 ({PACKINGSLIP_HEADER.S_ORDER_NO} , 0)

Problem is with @upstotal field, I need this to be a whole number. Field now is 2 place decimal.

Example Field now -->123.45
I need 123
Tried rounding, but it gives 123.00 etc...
Ideas?????

 

[Ngolem]

"({PACKINGSLIP_HEADER.S_ORDER_NO} & {@upstotal} , 0)"

Looks to me as though {@upstotal} is already in text format.

The final result of {@upstotal} could be

ToText(whatever-the-total-is,0,"","&quot

this will round the value to zero decimals and eliminate the decimal point and thousand separator

Hope this helps
Jim