karlo mark medina
asked on
Crystal report comparing two Running total fields?
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.