CYSTAL REPORT ISSUE DISCUSSION: i want the sum of Amount having different currencies in a Group i-e Deal Number;
here is the example below: DEALID DEALTYPE CLIENTTYPE CLIENT DATE SELL AMT ACT curr curr acocunt payee post ION ------------------------------------------------------------------------------------------------------------------------------------------------------------------ 35468 SPOT corporation client 10/10/2001 CAD 58 35468 SPOT corporation client 10/10/2001 USD 900 FEES CAD 58 Not assigned FEES YES FEES USD 900 Not assigned FEES YES ------------------------------------------------------------------------------------------------------------------------------------------------------------------- CAD 58 CAD 58 USD 900 USD 900 issue: i made a group on deal id but the issue is in total(SUM) field, dealing with different currencies, How i can do this.. if i use formula field how can i do this? Thanks Hussain
