I have a formula in my columns which calculate a percentage share. I know that I can use the built in OLAP percent function to do this but I can't use it. I have created a formula which says (A/B)*100. The value that is displayed doesn't have the "%" sign. How can I add the percentage sign without using the OLAP Percentage Share function?
You have to use the % formulas in order to get the % sign. If you do not, you can always do some specific formatting in Excel for workbooks, otherwise you need to use the %A formula.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.