Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Crystal report comparing two Running total fields?

Posted on 2014-10-13
Medium Priority
672 Views
i do have two total running fields which a summary of sum formula:
problem is how can i show wich of the two has higher value?

exaample

RUNNINGTOTAL1            RUNNINGTOTAL2
2                                        3

i must show in report RUNNINGTOTAL2 since it has higher value:

tried using this formula but didnt work it shows only blank section:
IF RUNNINGTOTAL1 > RUNNINGTOTAL2 THEN
RUNNINGTOTAL1  ELSE
RUNNINGTOTAL2

-karlo
0
Question by:karlo mark medina
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 101

Assisted Solution

mlmcc earned 1000 total points
ID: 40376963
What didn't work?

Are any of the values NULL?

If you put the running totals in that section what values do you see?

mlmcc
0

LVL 35

Accepted Solution

James0628 earned 1000 total points
ID: 40379763
Basically, what mlmcc said.  :-)  What you tried to do _seems_ OK, and a blank result does suggest that nulls might be the problem.

FWIW, a simpler way to do what you described would be something like
Maximum ( [ {#rtotal1}, {#rtotal2} ] )

But what you described should work too, so I would try to figure out why that isn't working first.

James
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
###### Suggested Courses
Course of the Month7 days, 14 hours left to enroll