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

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

    Yeo Poh sai

      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% ?