Grand Totals using Crystal Version 9 - (Peachtree Accounting Software)

[Former Member]

Post Author: mklafert

CA Forum: General

Before I made the posting I tried to create a new running total. But when I do that and it ask field to summerize then I cannot pick my formula field. Basically, what I need is a forumla that will calucate non-commission amounts from an invoice and then a grand total of that field. I have the formula that gives me the non-commison amout: non-commission = {JrnlHdr.MainAmount} - Sum ({@commission}, {JrnlHdr.Reference})*1 That works but I can't figure out how to get a grand total for this. I have another field "comm amt." Sum ({@commission}, {JrnlHdr.Reference}) * .10because these fields are summerized, I can't get a grand total or I am at a loss. I have tried all kinds of formulas. HELP!!!! PLEASE!!!Possible I need to change the formula to calcuate non-commission and the commision amount? I even tried to create another formula fiedl that would total both these fields and it would tell me "can't summerized this field"

[Former Member]

Post Author: mklafert

CA Forum: General

That didn't work for the fact that it created a running total in the non-commission field. I need to bread out the commission amount and non- commission per invoice. My formula field for commission works great and I can get a grand total. Commission formula is :

commission = If {LineItem.HasCommission}=TRUE then {JrnlRow.Amount} *-1

non-commission = {JrnlHdr.MainAmount} - Sum ({@commission}, {JrnlHdr.Reference})*1 - Non-commission is taking the total of the invoice (main amount) and subtracting the commission amount.

comm amt. = Sum ({@commission}, {JrnlHdr.Reference}) * .10 - this field is the commission amount times .10 (10%),which is the commission amount paid.

I can send the report if you would like. This is all I need to finish the report.

I made three " formula fields" one called comm-a (NUMBERVAR NonCommTot;) put it in the Report Header. Second one called comm-b (NUMBERVAR NonCommTot;NonCommTot := NonCommTot + {JrnlHdr.MainAmount} - Sum ({@commission}, {JrnlHdr.Reference})*1)

Third Formula called comm-c (NUMBERVAR NonCommTot) and put it in my report footer.

The result was that non-commission was a running total instead of the individual total for each invoice. Also, the Report Footer value was 0.00

I can send you the report if that will help.

Thanks Mary

I am assuming because I have the "SUM" command in the last two formula is why I can't get a grand total. Otherwise those formula gives me the values I want.

[Former Member]

Post Author: mklafert

CA Forum: General

That didn't work for the fact that it created a running total in the non-commission field. I need to bread out the commission amount and non- commission per invoice. My formula field for commission works great and I can get a grand total. Commission formula is :

commission = If {LineItem.HasCommission}=TRUE then {JrnlRow.Amount} *-1

non-commission = {JrnlHdr.MainAmount} - Sum ({@commission}, {JrnlHdr.Reference})*1 - Non-commission is taking the total of the invoice (main amount) and subtracting the commission amount.

comm amt. = Sum ({@commission}, {JrnlHdr.Reference}) * .10 - this field is the commission amount times .10 (10%),which is the commission amount paid.

I can send the report if you would like. This is all I need to finish the report.

I made three " formula fields" one called comm-a (NUMBERVAR NonCommTot;) put it in the Report Header. Second one called comm-b (NUMBERVAR NonCommTot;NonCommTot := NonCommTot + {JrnlHdr.MainAmount} - Sum ({@commission}, {JrnlHdr.Reference})*1)

Third Formula called comm-c (NUMBERVAR NonCommTot) and put it in my report footer.

The result was that non-commission was a running total instead of the individual total for each invoice. Also, the Report Footer value was 0.00

I am assuming because I have the "SUM" command in the last two formula is why I can't get a grand total. Otherwise those formula gives me the values I want.

[Former Member]

Post Author: Charliy

CA Forum: General

You need these three formulas:

In your report header (non-printing): NUMBERVAR NonCommTot :=0

In the Group Footer for the Reference group:

NUMBERVAR NonCommTot;

NonCommTot := NonCommTot + <your noncommission formula>

In Report Footer: NUMBERVAR NonCommTot