## Group specified on non-recurring field

## Group specified on non-recurring field

(OP)

I'm trying to write a report that will group the results by information that is only available by a Formula. CR is throwing an error stating "Group specified on a non-recurring field" and references the formula I've created. The formula is correct, but does not appear to be a valid formula for the group creation.

The formula is as follows:

To interpret, the formula is comparing whether the quantity allocated = the quantity picked for each Order Number. The data includes all lines of an order and needs to be summed to determine the status of the entire order. CR seems to have a problem with the sum function. Does anyone have a suggestion on how to create such a group?

The formula is as follows:

#### CODE -->

if sum({Command.QtyAllocated}, {Command.SAPOrdNo}) = sum({Command.Picked}, {Command.SAPOrdNo}) then "Picking Complete" else "Picking Not Complete"

To interpret, the formula is comparing whether the quantity allocated = the quantity picked for each Order Number. The data includes all lines of an order and needs to be summed to determine the status of the entire order. CR seems to have a problem with the sum function. Does anyone have a suggestion on how to create such a group?

Randy Davis

Denver, CO

## RE: Group specified on non-recurring field

## RE: Group specified on non-recurring field

-Dell

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

www.decisionfirst.com