Sum formula query

[KhushiRaina]

Hi,
Anyone knows how to use the formula
:- sum({fld},{condfld},{cond})
When i am trying to use as follows :-
Sum({orders.AMOUNT}, {orders.DATE}, "monthly&quot
It given an error -
A summary/running total field cannot be created.

Any suggestion.........ssssss

Khushi.

 

[kenhamady]

The condition field and condition has to match the current grouping of your report. So, this will only work in a report that is grouped on that date, and set to monthly. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[KhushiRaina]

Hi Ken hamady,
Its working!!!
Thanks a Ton,

Khushi.

 

[KhushiRaina]

Hi Ken,
Its working with date, but if i give
Sum ({Orders.Order Amount},{Orders.Order ID} , "1002&quot
its giving same error.I have done grouping on order id too.
What should i do now...

Khushi.

 

[kenhamady]

The third argument is only for dates. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[KhushiRaina]

Hi Ken,
Thanks for the info, i really appreciate for giving your valuable time.Thanks again.
Khushi