6 Replies Latest reply: Jul 11, 2013 9:34 AM by Jarrad Murray RSS

    Calculated Dimension help

    Jarrad Murray

      Hi All,

       

      I have an if statement with an embedded number function to display a dimension as either an integer or a percentage.  The code that I am using for this is =if(metrics_Number_or_percent='PERCENT',num(metrics_target,'#,##0%'),num(metrics_target,'#,##0')).

       

      The problem that I am facing is that a couple of the figures that should be coming out as numbers are coming through as percentages.

       

      Does anyone know if I am doing something wrong and/or how to fix this.

       

      Many thanks