1 Reply Latest reply: Jul 10, 2014 6:51 PM by PAUL YEO RSS

    How to add condition For IDR currency < 300 don't round otherwise round up 0.5

    PAUL YEO

      Hi All

       

       

      Below expression work fine , it only round up 0.5 when value more then 10.

       

       

        if ( column(1) <10 ,

        num( ( column(1)) , '#.##')  ,

        num( Ceil(  column(1),0.5) , '#.#') )

       

       

      Now i like to add one more condition , if user select :-

       

       

      Currency_P=SG value < 10 don't round other wise round up to 0.5

       

       

      Currency_P=INDO value < 300 don't round other wise round up to 0.5

       

       

      I assume the expression should be as following :-

       

       

      if Currency_P='SG',

        if ( column(1) <10 ,

        num( ( column(1)) , '#.##')  ,

        num( Ceil(  column(1),0.5) , '#.#') )

      if Currency_P='INDO',

        if ( column(1) <300 ,

        num( ( column(1)) , '#.##')  ,

        num( Ceil(  column(1),0.5) , '#.#') )

      ))

       

       

      But it does not work . Hope some one can advise me.

       

       

      Paul