slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: re: Running total formula

Chokri
Posts: 62

re: Running total formula Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Jun 07 9:41 AM

I am using Crystal v 8.5.

Can you tell me if/where I am going wrong with the following formula please

both are reset at a particular group

({#1~Count Subs Amount})-({#Actual Amount Count})

I basically want the above formula to give me the difference between the Subs amount minus the actual subs amount sold.
My formula on the first group is returning the correct difference. i.e

Subs Amount = 980
Actual subs amount sold = 784
Difference = 196

however on the next group it is bringing the following. i.e

Subs Amount = 196
Actual subs amount sold = 196
Difference = 784

The difference should be 0 - any help will be greatly appreciated.

[Reply][Quote]

Martin Rudnick
Posts: 52

Re: re: Running total formula Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Jun 07 9:30 AM

Have you tried creating the summary using the formula syntax of Sum({Sub},group) - Sum({Actual Sub},group) ala SummaryFunction (fld, condFld)?

[Reply][Quote]

Chokri
Posts: 62

Re: re: Running total formula Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Jun 07 4:47 AM

I did try this see below however I am getting the following error message 'The ) is missing' .

Sum ({#1~Count Subs Amount},GroupName {USERINFO.USERNAME})-({#Actual Amount Count},GroupName {USERINFO.USERNAME})

[Reply][Quote]

Martin Rudnick
Posts: 52

Re: re: Running total formula Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Jun 07 8:59 AM

The following may work:
Sum ({#1~Count Subs Amount},{USERINFO.USERNAME})-Sum({#Actual Amount Count},{USERINFO.USERNAME})

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 9:53:47 AM