The formula seemd to work for each record but it is not performing the analysis on all records and then sorting and grouping correclty. It does it record by record. I need all records analized and then grouped and sorted accordingly.
Thanks for your help.
Try this formula
If Field B >0 and Field A < Field B then "Paritally Recevied" else If Field A =Field B then "Recevied" else If Field B =0 then "Not Recevied"
insert a group using this formula tha gives three groups like
Partially recevied
Recevied
Not Recevied
Regards,
Raghavendra
Hi Derek,
You might need to include 'whilereadingrecords;' at the beginning to specify when the formula is to be evaluated. Groups are created during the whilereadingrecords phase, and may need to be added.
For example, create a new formula under the Field Explorer and enter the below syntax by replacing Field X with your database field. Then create a new group using your formula.
================================
whilereadingrecords;
If Field B >0 and Field A < Field B then "Paritally Recevied"
else If Field A =Field B then "Recevied"
else If Field B =0 then "Not Recevied"
================================
Regards,
Wallie
Add comment