Dear Hughes,
Thanks for your response. This works like a charm.
The NL("Sheets") function was also one of my filter-values for other formulas in the sheets, so I had to add another function to retreive the filter-value again.
Function Sheets:=NL("Sheets";"Company";"=""BS - "" & NF(;""Hyperion partnercode"")";"Name";Option_Company)
Function Company Filter:=NL("First";"Company";"Name";"Hyperion partnercode";MID(E3;6;LEN(E3)-5))
Once again, thanks for your solution!!!
Kind regards,
Gerard
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Gerard,
Hmm, you probably have to use a calculated field to do this. Try something like this:=NL("Sheets","company","=""PL ""&NF(,""Name"")")=NL("Sheets","company","=""BS ""&NF(,""Name"")")
Do those work for you?
Regards,
Hughes -
Jet Reports Historic Posts Sorry if I missed it, but I couldn't find a post related to this question.
In one of my reports, I have two sheets containing a NL("Sheets") function on the companyname. One for presenting the balance sheet and one for the profit and loss. By default the first function creates sheets with a name like "Company Name" and the second "Company Name (2)".
What I would like to achieve is:
- "BS - Company Name"
- "PL - Company Name"
Tried different CONCATENATE-options, but none worked unfortunately.
Does anyone know if this is possible? Thanks in advance!!!
Regards,
Gerard
Please sign in to leave a comment.