AnsweredAssumed Answered

Related counts

Question asked by glorifindal on May 12, 2014
Latest reply on May 13, 2014 by glorifindal

I am looking for a way to do some related counts in FM11:

 

I have the following relationship: Admin -> Orders -> Services

 

Where Admin is simply the context from where I run reports, etc

 

I need to know how many Orders have the following...

 

0 Services

1 Service

2 Services

3 Services

More than 3 Services

 

I could of course create 5 fields in the data file, and run the script against each of the 5 fields.

 

... but I am unable at the moment to modify the data file (using seperation model)

So, I need to do this per script.

 

Does anyone have a suggestion?

 

Many thanks in advance

Outcomes