i was trying to create a report in which i want to count group totals only if they are greater than 0. Does anyone know how to write this formula.

 

I am trying to create a payment edit list in which the report pulls in all the invoices that are due for payment. Among these invoices, there are some credit memos which have negative balances and no checks will be be written. They are grouped by vendor totals (A vendor could have multiple invoices). I want to count the group total only if its greater than 0, in other words how many checks to write. since i am not going to write checks for credit memos (negative amounts), i dont want to include them in my could.

 

In excel i would've write is as : Countif (Vendor Group Total) > 0

 

Any help is greatly appreciated......

Checks to write:   If the Group total > 0 then 1 else 0

Summary : Sum (checks to write)

 

My problem is that it's not letting me sumarize the "checks to write" formula.

 

"Count" = if Sum ({APInvHed.InvoiceAmt}, {APInvHed.Calc_SupplierName})>0 then 1 else 0

 

The above formula just takes the goup total for each supplier and if that total is greater than 0 then 1      : Formula below was trying to sum this "count" formula of all the 1's.

 

"Sum": = sum{@count}

 

When i try to compile "Sum" i get the message : "The remaining text does not appear to be part of the formula"

 

how are you determining the group footer "x"

so now to go with the count you also need a corresponding SUM ?

make a new Running Total