2 Replies Latest reply: Apr 12, 2013 5:40 PM by Torunn Midtsjo RSS

    Number format in text box

    Torunn Midtsjo

      Hi!

       

      I have the following expression:

       

      =NuUM(SUM({<CASES.TYPE={'INCIDENT'},CATEGORY={'INCIDENT'},CASEDATES.OPEN_TIME_NUM={'>$(=$(vToday)-1)'}>}CASES.COUNTER)
      -
      SUM({<CASES.TYPE={'REQUEST'},CATEGORY={'REQUEST'},CASEDATES.OPEN_TIME_NUM={'>$(=$(vToday)-1)'}>}CASES.COUNTER),'##0;(##0)')

       

      This works fine, but I want to change the number format. 

       

      In case the result is a positive number I want a minus symbol in front of the positive number . For example:  - 76.

       

      In case the result is a negative number I want a plus symbol in front of the negative number. For example + 81

       

      Is this possible?  I have tried to change the format, but have not succeeded in getting the result I want.

       

      Best regards

      Torunn