21 Replies Latest reply: Jan 9, 2016 11:40 AM by Jim Chan RSS

    How to add percentage format in expression?

    Jim Chan

      Hey guys,

       

      I want to write this in my loading script instead as a expression at my front end.

       

      it doesn't seem to work. Suppose i should get "100%" but, it is still showing me "1.00". i have tried many of time. is it because i cant write this expression in my loading script?

       

      num((sum(if(FRAUD_RESULT=1 ,COUNT))), '#,##0%') as rc_count,

       

      rgds.

       

      Jim