I'd like to display positive numbers on a trend report with a + sign in front of them.
I tried:
CASE WHEN [field] > 0 THEN '+'||[field] ELSE [field] END
...and that didn't work.
Is this possible?
Hi,
Did you try adding a text item and rendering based on the value > 0 ?
Good luck
New guy
I think you could do this with a format string, e.g. +#,0.00;-#,0.00;"0.00";"null";
The first spec is positive values, second negative, third 0 values, fourth nulls.