you can't sum different currencies. What would you call your summed currency?
On Fri, Dec 26, 2008 at 2:28 AM, Mohammed.hussain <[email protected]>wrote: > > 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 > > > -- Charles A. Lopez [email protected] Bachelor of Arts - Computer Science New York University Registered Microsoft Partner New York City, NY
