Hello, I am looking at a specific situation where I need to return a number of unique values for a global dimension (LIN code) that fall under a certain G/L account number for a given Award number. So for example, for Award 32029 I need to replicate all LIN codes that have charged actuals against G/L account 8000 in the G/L Entry table.
Any thoughts on a formula or solution would be helpful.
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi!
I would be helpful to show what your current formula looks like and where you are stuck. What does your current formula not do correctly? Are you having problems getting unique values or linking from the G/L Account to G/L Entry table or something else?
Regards,
Hughes -
Jet Reports Historic Posts Thanks for the response. I don't really have a formula yet. I am working to return unique values of one global dimension that fall under a G/L account number. For example we have a subcontracting G/L account number (8000). We set up subcontractors to book against a LIN Code which is a global dimension. I would like to build a formula that returns each LIN Code under the G/L code 8000 for a given award number.
I was thinking about using N/L rows but it returns the entire row not just the unique LIN Code field. Trying to get to a starting point. I'll continue to play around and if I put together a formula I'll drop it in here. -
Jet Reports Historic Posts So I think you would just do something like this:
=NL("Rows","G/L Account","LIN Code","No.","8000")
This should return the unique values of the LIN Code dimension that have G/L Account table. On the other hand, if you need to do something where you filter on G/L Entries or you want to see the LIN Codes that have G/L activity, then you might want to replicate them out of the G/L Entry table like this:=NL("Rows","G/L Entry","LIN Code","G/L Account No.","8000")
Does this make sense to you?
Regards,
Hughes
Please sign in to leave a comment.