Forum Discussion
Bond speak
I am working with some data that is stored in a table, but it's stored in terms of "Bond speak". In otherwords the digits to the right of the decimal place represent how many 32'nds are in the data.
Stored as - But for calculations I need to convert to decimal
| 100.06 | 100.1875 |
| 101.22 | 101.6875 |
| 102.15 | 102.4688 |
It's very old school bond way of speaking. Most of my other software packages I work with are geared towards the industry and have simple functions to convert numbers to decimal format. I can't find anything similar in PBI.
You can get there with a couple of steps.
- Split the column by "."
- multiply the second column by 1/32 (you might have to change its type to decimal number)
- Add a custom column which adds the two back together
After that you can delete the two split columns and just keep what you need.
1 Reply
You can get there with a couple of steps.
- Split the column by "."
- multiply the second column by 1/32 (you might have to change its type to decimal number)
- Add a custom column which adds the two back together
After that you can delete the two split columns and just keep what you need.