8 Replies Latest reply: Mar 30, 2016 4:51 AM by Gysbert Wassenaar RSS

    Number formatting using if condition not working

    Brijesh Maurya

      Hi All,

       

      i have created inline ,

       

      TrendView:

      Load * Inline [

      %View, Format

      Number , 1

      Percent,  2

      ];

       

      And say i have expression like

      if (format = 1 ,Sum(Aggr(Bounces,VisitFull)) ,Num((Sum(Aggr(Bounces,VisitFull))/Sum(Aggr(Visits,VisitFull))),'#,##0.00%')

      )

       

      and created a List box for View Number , format

       

      if i select Number is shows the value and if i select it showing value but not percentage calculated and without % sign..

       

      if am i putting an expression Num((Sum(Aggr(Bounces,VisitFull))/Sum(Aggr(Visits,VisitFull))),'#,##0.00%')   without if condition

      it working fine...

       

      can any one help me to sort out this