I'm trying to create rows (using the NL function) and subtotal the rows by unique combinations of the 3rd and 4th characters in a dimension (Outlet).
The NL Row formula is =NL("Rows","Dimension Value",,"Dimension Code","Outlet","Code",$B22)
Where B22 = ??A*?*..??A*?*,but although this filter selects the 3rd character starting with A it groups all of the A's together and does not self generate rows for additional combinations of the 3rd and 4th characters. My file is attached. Any suggestions would be much appreciated.
Date
Votes
2 comments
-
Jet Reports Historic Posts How about:
=NL("Rows","Dimension Value","=MID(NF(,""Code""),3,2)","Dimension Code","Outlet")
That will return the 2 character combinations.
If you wanted to use it in your G/L or something (assume for this example that outlet is global dimension 1 code, and that the above is in C5):
=NL("Sum","G/L Entry","Amount","=MID(NF(,""Global Dimension 1 Code""),3,2)",C5)
It won't be very quick! -
Jet Reports Historic Posts Thanks Teresa :D ! This formula worked great and did just what I needed.
=NL("Rows","Dimension Value","=MID(NF(,""Code""),3,2)","Dimension Code","Outlet")
This post is resolved even though I can't find where to mark it so. Thanks again!
Please sign in to leave a comment.