Same data is in multiple groups problem 1

[kernal]

I'm using crystal 9 with a csv file

csv file:

subject id
PRE 100
PRE 110
PRE 200
PRE 212
PRE 300

The problem that I am having is that some of these id numbers might be in different groups and if I use else if then in a formula, it only finds it in the first group (finance) where the id is listed.

if subject='PRE'
and
id in [100,110,200]
then
'Finance'
else if
subject='PRE'
and
id in [100,200,300]
then
'Professional'
etc.

Help is appreciated

 

[lbass]

A record can only be evaluated by an if/then formula once, so once it meets the first criterion in the if/then, it has been evaluated, and the if/then goes on to the next record.

Similarly, one record can appear in only one group. If you have two records with 'pre' and '100', for example, then there must be some other field that distinguishes the two records, and you could potentially group or distinguish the records based on that.

-LB

 

[kernal]

Thanks lbass. I'll just create different reports for each group since subject and id are the fields used to identify the groupings and there are no other fields that can be used. I appreciate your help.