How do I enter a filter that is <=H7 where H7 a value being returned on a line. for example, I want to return the Creation date from the G/L Register, Using the NL Last function I get the entry number from the G/L Entry (H7) and I want the find the Last entry in the register that is less or equal to the g/l entry number. Jet will not let me enter =NL("Last","G/L Register","Creation Date","To Entry No.",<=H7). What am I doing wrong?
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi,
Are you saying that H7 is the cell reference with the entry number or that is the entry number itself? I would assume you mean that H7 is a cell reference in which case you probably want to do something like this:=NL("Last","G/L Register","Creation Date","To Entry No.",".."&H7)
If you mean that H7 is the actual entry number then it would look more like this:=NL("Last","G/L Register","Creation Date","To Entry No.","..H7")
Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi
Thanks for the advice but I can't get it to work. The problem is in putting an operator in front of a cell reference in a filter.
In the example discussed H7 reperesents an Entry Number. The Register gives a series of From and To Values. for examle:
From Entry To Entry
100 110
111 125
H7 represents a Value - say 121, I need to find out which range this entry falls into. I have tried your suggestions but to no resullt.
Logicly I am looking for the First entry that is equal to or greater than H7 '>= H7' or the Last entry that is equal to or less than H7 '<=H7' -
Jet Reports Historic Posts The first formula I gave you above should give you the last creation with a To Entry No. that is less than or equal to the value in cell H7, which I believe is what you want. Did you actually run the report (Jet -> Report)? Jet formulas like NL(Last) do not work unless you actually run the report. Also, if it's still not working, you may need to add a sort to your formula to sort by the "To Entry No.".
Regards,
Hughes
Please sign in to leave a comment.