I am trying to create a report that creates a separate tab for each cost center (segment 1). It will also produce all accounts with data for that cost center but needs to exclude a few accounts. I tried using the formula =GL("Rows","Accounts",,,,,C15,D15)-GL("Rows","Accounts",,,,,C15,7100,"00100..00190").
But I get an error that says The function in cell \$F\$15 is not a valid replicator. Ensure that the replicator function is the only text in the cell. F15 is where the formula is.

I have run this report successfully for the first half of the equation (before minus sign) and also successfully for the 2nd half of the equation (after minus sign).
On the first half, C15 refers to sheets for the first segment and I’m wondering if that’s causing an issue. D15 is referencing all 5*|6*|7*|8*|. That works perfectly.
On the 2nd half, C15 is the same, but I'm specifically noting that segment 2 is 7100 and segment 3 is the range 00100 to 00190.

We use MS Great Plains. If you can help me with this formula, I'd appreciate it. Thanks.

#### 2 comments

• Jet Reports Historic Posts

You could probably list the accounts you are after by using these 4 functions:

=GL("Rows","Accounts",,,,,C15,"5*|6*)

=GL("Rows","Accounts",,,,,C15,70*")

=GL("Rows","Accounts",,,,,C15,7100,"00000..00099|00191..99999")

=GL("Rows","Accounts",,,,,C15,"72*|73*|74*|75*|76*|77*|78*|79*|8*")

the first lists those accounts beginning with a 5 or 6. The next, those accounts starting with 70. Next, those 7100 accounts EXCEPT where segment two is between 00100 and 00190 (inclusive). The final function lists those where segment 1 starts with 72..79 or 8.

I hope that helps.

• Jet Reports Historic Posts

Thank you very much. This was very helpful.

Please sign in to leave a comment.