Crystal Sum with two conditions

crystal-reports crystal-reports-2008
user455580 picture user455580 · Dec 2, 2010 · Viewed 9.2k times · Source

I am trying to get summary by two conditions, much like Sumifs function of excel Like - Sum(Total_Costs) where Region = 4 and Currency = USD. Thanks in advance

Answer

Adriaan Stander picture Adriaan Stander · Dec 2, 2010

You will have to create a Formula called @Region4USD

Something like

if ({YourReport.Region} = 4 and {YourReport.Curency} = "USD") then
    {YourReport.Total_Cost}
else
    0

Then create a SUM on the formula

Related questions

How do I point Crystal Reports at a new database

I have a Crystal Reports 2008 user that has over 100 custom developed reports. The reports all query Sql Server databases (SQL 2005). This database server is getting replaced with a new system (running SQL 2008 R2) and the existing databases will be moved …

Read More
Crystal Reports Custom IsNull Function

I am trying to create a custom IsNull Function in Crystal Reports; the function must act the same way as the IsNull Function in MS SQL Server. I want to specify a field, and if the field is null, then …

Read More
extract raw SQL query from a Crystal Report .rpt file

I've got an .rpt file that I did not write and can find no documentation about. I want to be able to review the SQL that is generated from this report so that I can figure out, well, what data …

Read More