Crystal Sum with two conditions

Question

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 1

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

Answer 2

You can create a running total. That way, you have the option of using the "Evaluate" section to use your own conditions when you click on the "Use formula" option.