1
|
2
|
3
|
4
|
|
Version 1
|
$10.00
|
01/10/2019
|
1
|
string
|
Version 2
|
10
|
20191001
|
true
|
“string”
|
+
|
MIN
|
MIN
|
|
Version 1
|
2 + ‘blank’ = NaN
|
MIN(‘blank’,1) = NaN
|
MIN(‘blank’,-1) = NaN
|
Version 2
|
2 + ‘blank’ = 2
|
MIN(‘blank’,1) = 1
|
MIN(‘blank’,-1) = -1
|
Age
|
IF
|
Concatenate
|
|
Version 1
|
1
|
IF('Age'="", "", 'Age' + 1) = Column not created
|
ABS( CONCATENATE("-", "1")) = Column not created
|
Version 2
|
1
|
IF('Age'="", "", 'Age' + 1) = 2
|
ABS( CONCATENATE("-", "1")) = 1
|