Skip to Content
0
Former Member
May 09, 2012 at 03:41 PM

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

56 Views

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.