Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Create groups based on formula results

I've got a report where I need custom groupings based on a formula. Two fields need to be compared against one another. Based on the results groups need to be created. The results wll be 3 scenarios resulting in 3 different status possibilities:

Scenario 1 - If Field B >0 and Field A < Field B then Status ="Paritally Recevied"

Scenario 2 - If Field A =Field B then Status ="Recevied"

Scenario 3 - If Field B =0 then Status ="Not Recevied"

So the 3 groups would be Partially Received, Received, Not Received and all are based on running all report records through the formula before displaying them in those groups.

I have no idea of the correct syntax for this but have soem experince in the Crystal Reports formula deisgner. I also don't know how to add the correct formula to the group paramters,

Any help is appreciated.

Former Member

Hi Derek,

Did you create a group on the formula, by going to the menu Insert|Group... and selecting the formula you created?



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question