Sum If

[naungsai]

Dear Friends

In my report I have 2 Columns, "Currency" and "Cost".
The "Currency" values are Euro, Dollar. I want to sum the "Cost" in different "Currency" in the report.
My column in report looks like this.
Activity............. Currency..................Cost
Activity1............ Euro....................... 10
Activity2............ Euro....................... 10
Activity3............ $............................ 10
Activity4............ Euro....................... 10
Activity5............ $............................ 10

I want my report to sum as followed.
Total..................Euro........................30
Total..................$............................20

Please help me.

 

[Rabbie]

Try something like this for euro total box

=Sum(iif(currency="euro",Cost,0)

and for $ box try

=Sum(iif(currency="$",Cost,0)

 

[naungsai]

Thanks.
It works well.

 

[Rabbie]

happy to have been of help