So I think the easiest way to do this would be to just use separate cells and then hide the columns with the intermediate results. So for example:B2:
=NL(,"Table 2","Sequence","Vehicle","@@")
C5:
=NL("Rows","Table 1","Vehicle")
D5:
=NL(,"Table 2","Sequence","Vehicle",C5)
E5:
=IF(D5="",$B$2,D5)
F5:
=NL(,"Table 3","Chart Out Rate","Sequence",E5)
So I put the sequence number for the standard change in cell B2 since it sounds like that doesn't change by vehicle. You could also put Hide in D1 and E1 if you wanted to hide those results when running the report. Does something like this work for you?
Regards,
Hughes
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi,
I’m trying to return the vehicle charge out rate. This requires information from 3 tables.
Table 1 has Vehicle #, Hours used
Table 2 has Vehicle #(not every vehicle has its own sequence #), Sequence # (each charge out rate has its own Seq #)
Table 3 has Sequence #, Charge Out Rate
My issue is with Table 2, if the vehicle has a unique charge out rate it has its own line in the table linking the vehicle # and sequence # but if it is a standard charge out there is a line in the table with no vehicle #(blank) and an associated sequence #.
How do I write a formula to take the associated sequence # if the vehicle #’s match in Table 1 & 2 but take the sequence # associated to the blank Vehicle # if there is not a matching vehicle #? -
Jet Reports Historic Posts Thanks, I think that might work.
Please sign in to leave a comment.