I have a function that currently returns the correct value as a sum of hours worked for all clients. I am trying to modify it to return all hours worked for all but a few clients. I can hard code in the client codes to filter on, but I would like to be able to read the values to filter on from a named range in order to allow the end user to add more clients to filter on.
Using a named range of 'FilterValues' that encompasses multiple cells each containing a single client code i tried the following but it did not work:=NL("Filter","WorkOrdersDefaultCustomer","WorkOrderKey","ClientCode",FilterValue,"Schema=",Options!D15)
I can create a single cell on the options page containing ClientCode1 &"|" & ClientCode2 & "|" & ClientCode3 …. and then reference that in the formula, but I would prefer to have 2 columns, one with client name and one with client code if that is possible.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
You definitely can put your client codes in a range of cells and reference that from your formula the way you are describing. What range is your FilterValue named range actually referencing? Are you referencing 2 columns with names and codes or just one column with codes? If you reference the single column with just the codes in it, that should work correctly. Of course the 2nd column with the names can exist, but just don't make that part of the named range you use in the formula. Does that work for you?
Regards,
Hughes
Please sign in to leave a comment.