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.
(Visited 48 times, 1 visits today)
Can you use the ows_Price (or the one that is not _q_) managed property and let me know what value comes through?
(Visited 1 times, 1 visits today)
Karen commented on answer August 9, 2017
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!