Report total

[dikidushi]

Hi,

Can anyone help me creating a formula total?

Total sales minus returned amount then total my current formula looks like this

{ProductLine.Quantity} * {ProductLine.QuotedPrice}
{CreditNotes.Returned} * {CreditNotes.Price}
{@total} - {@credit}

but it returns the wrong total amount.

Any help will be great.
Thnx

 

[IanWaterman]

YOu need to give more information as to how you are using these formula.

Where have you placed them in the report, I assume the first two are detail formula?

If you try to use the last one in report footer you will only get the values of the last record.

You could try

//@reporttotal
sum({@total}) - sum({@credit})

Ian

 

[dikidushi]

Hi Ian,

What i'm trying to achieve is to end total in a subreport,

i want to have a total of sales by period.

i need the total only after removing the sales returned, now if i run the subreport i get the total sales amount but including returned sales amount,

its a by period report just t show sales amount excluding sales return, i am using CR 10 and SQL 2005

thanx

 

[IanWaterman]

Did you try my suggested formula, that should give you what you want.

Ian

 

[dikidushi]

Yes it multiply the total

i need it to extract the return from the total sales

 

[lbass]

You are not supplying enough information. Is this calculation occurring entirely within the subreport? If not, you need to explain the main report structure, identify the section containing the subreport, explain what part of the calculation is coming from the main report vs. the subreport, how the sub is linked to the main report. Also explain whether the calculation is for the report as a whole or per some group.

It would also help if you showed some mock data, along with expected results vs. the results you are getting.

-LB

 

[dikidushi]

Hi Lbass,

Sorry for this late response.

I'm using only subreport the total for each row must have the crrect total,

my formula for each row total is ( quantity sold equals price is the sales amount) now i need ta create a formula that states ( total amount minus total returns is total per row for each month and each customer.

 

[lbass]

Your response is unclear and, unfortunately, still insufficient for us to identify the problem.

-LB

 

[dikidushi]

Oke,

i have a cross tab report, no subreport.
this is what i would like to accomplish
1. Salesamt * salesqty = total
2. Salesreturnqty * salesreturnamount = total

my end total for each column must be

total of 1-2= end total

maybe i'm still unclear :-(

 

[lbass]

How is the crosstab report set up? What fields are you using for the rows and columns? What is the actual content of the two formulas you are using for the summary fields? Please paste the formulas into the thread.

-LB

 

[dikidushi]

I am using the tables ICSTATI.SALESQTY and ICSTATI.SALESAMT
I/C statistic report from accpac, in that table ICSTATI i want to make a formula that is ICSTATI.SALESAMT - ICSTATI.SALESAMTRTN is total sales in each column for each month and customer.

 

[lbass]

You didn't respond to my requests.

-LB