IF(
[Class]=1,[Value]*POWER(16, 0),
[Class]=2,[Value]*POWER(16, 1)+[Value (1)]*POWER(16, 0),
[Class]=3,[Value]*POWER(16, 2)+[Value (1)]*POWER(16, 1)+[Value (2)]*POWER(16, 0),
[Class]=4,[Value]*POWER(16, 3)+[Value (1)]*POWER(16, 2)+[Value (2)]*POWER(16, 1)+[Value (3)]*POWER(16,0)
,
null)
Hex2Dec.JPG | 67K | |
HexConvert2Decimal.iok | 11K |
SCRIPT('parseInt(valueToConvert, 16)', "valueToConvert", REFVAL("Hex"), 10000)
"Hex"
is the field which contains hex value (Example attached). HexConvert2Decimal.iok | 7K |
It looks like you're new here. If you want to get involved, click one of these buttons!