I don't see a meaning in summing up different currencies, but if it's multiple summations that you're looking for then use Running Totals on a conditional formula by currency name/ID.
On Dec 26, 12:39 pm, [email protected] wrote: > I agree with charles. You should convert your CAD to USD or vice versa, and > then compute sum. > > --- Original Message --- > From:"Charles A. Lopez" <[email protected]> > Sent:Fri 12/26/08 10:01 am > To:[email protected] > > Subj:[DotNetDevelopment] Re: Crystal Report: Sum discussion > > 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
