Crystal Report Group Amount total in Report Foooter

Question

there is one company with 5 currency

EUR  
GBP  
PKR  
AED  
USD  

I have inserted a group w.r.t currency and its showing currency total after each currency

I want to show each currency total in the report footer. I have tried to insert the summary of Balance amount with group of currency, but its only showing the total of last currency which is in my case USD.

Is there a way to post each currency total in the report footer like this

**PKR Total   Amount  
**EUR Total   Amount  
**AED Total   Amount  
**GBP Total   Amount  
**USD Total   Amount 

Answer 1

you can

Create these 5 formulas

(if {Tablename with currency code} = "PKR" then  {table with Balance})  
(if {Tablename with currency code} = "USD" then  {table with Balance})  
(if {Tablename with currency code} = "GBP" then  {table with Balance})   
(if {Tablename with currency code} = "AED" then  {table with Balance})   
(if {Tablename with currency code} = "EUR" then  {table with Balance})  

at the report footer take a summary of this formula