Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference ZONE
Functions and Expressions Reference Guide
226
Positive Zoned Value
Integer Value sign_indicator = 0 sign_indicator = 1
1236 1236 123F
1237 1237 123G
1238 1238 123H
1239 1239 123I
Negative Zoned Value
Integer Value sign_indicator = 0 sign_indicator = 1
-1230 123} 123}
-1231 123J 123J
-1232 123K 123K
-1233 123L 123L
-1234 123M 123M
-1235 123N 123N
-1236 123O 123O
-1237 123P 123P
-1238 123Q 123Q
-1239 123R 123R
Examples
ZONE ( 1234 , 0 )
returns 1234.
ZONE ( 1234 , 1 )
returns 123D.
ZONE ( –1234 , 1 )
returns 123M.
ZONE ( INT ( UnitPrice * 100 ) , 1 )