Count a Formula 1

[OLTU]

Hi,

Using 8.5 version.

I need a help for issue below.

I've a formula named {@roundcalculteorders} which I can't get the total for this because this is not showing when I'm looking in function Insert--> Subtotal/Grandtotal or Summary.

First I create a formula like:

{@Calculateorders}and insert:
if GroupName ({ORDER.NAME})="CLOSE" then Sum ({@Volume}, {ORDERDETAIL.PACKKEY})/0.656

Then I create another formula like:
{@roundcalculateorders} and insert:
-int (-{@Calculateorders})

This works but now I want to sum the {@roundcalculteorders}

Groupheader: Orders
======
Details: 5 {@roundcalculteorders}
2 {@roundcalculteorders}
3 {@roundcalculteorders}
5 {@roundcalculteorders} +
===============================
Should gives 15

Thx.

 

[GJParker]

Use the 3 formula method

//@Reset - Place in Group header and suppress
WhilePrintingRecords;
Shared NumberVar Total := 0;

//@Accumulate - Place in detail section and suppress
WhilePrintingRecords;
Shared NumberVar Total := Total + {@roundcalculteorders};

//@Display - Place in Group footer section
WhilePrintingRecords;
Shared NumberVar Total;

HTH




Gary Parker
MIS Data Analyst
Manchester, England

 

[OLTU]

Hi GJPARKER.

thx, it works.