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