I’m using the following formula hoping to get the last 4 digits of a number
Right (totext({tablefield}),4) But it gives me only the last digit.
Table field result
1.5,138 8.00
2.14,008 8.00
3.129 9.00
If my formula is wrong, can anyone help me with it.
I want the result to be 1 – 5138
2 – 4008
3 – 0129
I know that getting 0129 is another issue but don’t know how to get that too.
Any help with this is much appreciated
Working with CR 8.5 & DB2
Right (totext({tablefield}),4) But it gives me only the last digit.
Table field result
1.5,138 8.00
2.14,008 8.00
3.129 9.00
If my formula is wrong, can anyone help me with it.
I want the result to be 1 – 5138
2 – 4008
3 – 0129
I know that getting 0129 is another issue but don’t know how to get that too.
Any help with this is much appreciated
Working with CR 8.5 & DB2