Projects: Report Painter-hierarchy reports-Project Systems formatting change

[Former Member]

Greetings,

How can the following be accomplished in Report Painter Hierarchy reports (CJE5) for a calculated column:

If the results are negative, then report should display zero (0)? 

For example the results of a column is obtained by subtracting values of 2 other columns: 

         Column A       Column B              Column C

value     10                    30                    30-10   = 20     --> show this as 20

value     40                    20                    20 - 40 = -20   --> want to show this as "0"

Any suggestions is grealty appreciated

B.A.

[Former Member]

Not sure but i doubt whether this would be possible in the report painter reports. Instead you can think of developing a custom report to achieve this.