Number format in text box

[Anonymous]

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

[#2 · Accepted solution]

Hello,

Try using a conditional and concaternar information with '+' & field or '-' & Field.

Rebeca

[Anonymous]

Thank's for the reply!

I shall try your proposed solution.

Best regards

Torunn