7 Replies Latest reply: Sep 18, 2013 8:26 AM by Sverre Ardø RSS

    Trouble with digits/format

      The format is showing a column that I don't want and that column appeared after I inserted this code in the pivot table.


      =Sum(Bokførtverdi)&'     '&(Sum(Bokførtverdi)/sum(Total(Bokførtverdi))*100 &' %')


      It would also be nice to limit the number of digits on the percentage to two, is there some kind of round function that is available?