How to hide % sign in query
This is going to be an easy one for you guys but I cant seems to get it right this time.
I have a query which calculates variance. In the value displayed, it shows the percentage sign, % next to it, e.g. 10%.
However, my user requested this % sign to be removed as it has been described in the column header itself as % Variance.
So, how can I remove the % sign from my query?
Create a formula and use the NODIM function.
Hope it helps.