Hi All
I wonder if someone could please help with an issue I am having.
I have a custom list which has an indexed currency column called Price. I crawled the list and have a crawled property of Ows_q_CURR_Price which I mapped to a refinablestring for a content search web part.
Instead of getting £10.50 I get 10.5000000000000 and I’ve searched and searched and cannot work out how to get the £ sign and 2 decimals to show which is how that column is set up.
Any help or ideas would be greatly received.
Hi Beau, thanks for the information, I’ll check it out. In the end, I had to get it done, so I created a new single line of text column called PriceText and input the price that way. It’s up and working, but I’ll take a look at your link to see if I can edit and do it better. Thanks
I would say the best bet is to modify the display template in search, and convert the value of the field to use the new format.
Check this link out. It’s about creating custom display templates.
https://dev.office.com/sharepoint/docs/general-development/sharepoint-design-manager-display-templates
Can you use the ows_Price (or the one that is not _q_) managed property and let me know what value comes through?
Hi, thanks very much for the response. I have tried mapping ows_Price to a refinablestring and I just get the number without the currency symbol. Also if the number is 72.00 it will show 72 and if it’s 72.50, it will show 72.5, so doesn’t really work for me. I’ve searched and wracked my brains and cannot work out what I should do!