Sum running total and if then statement with running total Help

[jlr123]

Here are my three totals that I need to sum:
{#RTotal1}*.0125
{#RTotal0}*.0125
IF ({AR_Customer.SalespersonNo} = "BSB") AND {#RTotal0}>= 76930 then ({#RTotal0}-76930) *.050 ELSE 0.00

I created a variable to sum but it is not working (it prints "false"). I put it in report footer and my other calculations are in Group Footer #1

whileprintingrecords;
numbervar TotCommSum;
TotCommSum=TotCommSum+{@Svccommamt}+{@salecommamt}+{@bonuscom}

Thanks for your help.

 

[pmax9999]

Try this:

1. Amend the formula as follows (note, to set a variable value you need to use ":=", not "="):

whileprintingrecords;
numbervar TotCommSum;
TotCommSum [highlight #FCE94F]:[/highlight]= TotCommSum+{@Svccommamt}+{@salecommamt}+{@bonuscom}

2. Move that formula to GF1 (it can be suppressed in need),
3. To display the total, add the following formula to the RF:

whileprintingrecords;
numbervar TotCommSum;

Hope this helps. Let me now how it goes.

Cheers
Pete

 

[jlr123]

Perfect! Thanks so much!

 

[hilfy]

Is there a specific reason why you're using a variable? Is the value needed in another formula? If it's not, then change it to something like this:

whileprintingrecords;
TotCommSum+{@Svccommamt}+{@salecommamt}+{@bonuscom}

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com