Solved

Crystal report comparing two Running total fields?

Posted on 2014-10-13
2
663 Views
Last Modified: 2014-10-14
Hi Experts, Please help me creating my report
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

please help guys



-karlo
0
Comment
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
  • Learn & ask questions
2 Comments
 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 250 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

by:
James0628 earned 250 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question