TS won’t process numbers unless you pass them through a number formatter using
format= or @FORMAT or @CALC
I suspect the default precision on your database is different now, what was 0
is now 6. Might also be a quirk of a new ODBC connector (maintaining more
precision).
If the column type
Format=“num:us-accounting”
Peter
On Jun 19, 2018, at 4:25 PM, D Mark Weiss
mailto:dadwe...@mac.com>> wrote:
Steve,
Don’t know about an ini type setting.
<@var request$InventoryValues[<@var request$InventoryRow>,InOwnerAvailable2]
format:num:US-accounting> if you want dollar sign
<@var
If you changed the DB server, might you be using a default floating
datatype instead of integer for the column?
On 6/19/18 12:24 PM, D Mark Weiss wrote:
> Steve,
>
> Don’t know about an ini type setting.
>
> <@var request$InventoryValues[<@var
> request$InventoryRow>,InOwnerAvailable2]
Steve,
Don’t know about an ini type setting.
<@var request$InventoryValues[<@var request$InventoryRow>,InOwnerAvailable2]
format:num:US-accounting> if you want dollar sign
<@var request$InventoryValues[<@var request$InventoryRow>,InOwnerAvailable2]
format:num:comma-integer> if you want