17 Replies Latest reply: Jun 1, 2016 5:32 AM by Tamil Nagaraj RSS

    LY net profit -ve and CY +ve How to make the % column display as +ve % ?

    PAUL YEO

      Hi All

       

       

      I have below expression work fine for last 8 yr :-

      =if((column(1)+column(2))=0,0,(if(fabs(column(1))=0,1,column(2) / column(1)-1)))

       

       

      Now i need to measure net profit , when LY value can be -ve and CY value can be +ve i start to encounter issue.

       

       

      it is possible to make display of -278% change to +278% ?

       

       

      Paul