2 Replies Latest reply on Mar 21, 2013 8:46 AM by Allan Walker

    Side-by-side formatting as %

    Allan Walker

      Hi,

       

      I have two calculated fields "SUM[CF-Pass]" and "SUM[CF-DFW]".  I put these as rows as Measured values, and on the column shelf [CF-Semester and Year] (it's a pseudo date format because of the three semester system) and the measured values filtered as CF-Pass and CF-DFW.

       

      Problem - I can't get this to format as a percentage.

       

      Side-by-side.png

      I know I can do table calculations, but because these are CF's, it's not working as expected.  Is this because I don't have a date type?

       

      Side-by-side.png

      This is the closest I get (across table rather than across pane) but it's obviously wrong.  Any suggestions?