Crystal condition with two conditions

Question

I am trying to get a resume under two conditions, as well as the Sumifs excel Like - Sum (Total_Costs) function, where Region = 4 and Currency = USD. thanks in advance

Answer 1

You will need to create the formula @ Region4USD

Sort of

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

Then create a SUM using the formula

Answer 2

You can create a total. Thus, you can use the Rate section to use your own conditions when you click Use Formula.