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