Daniel February 2016
Getting first 3 chars from "Job No." to use as filter - Jet Reports
I am struggling to get the Quantities from the Job Ledger Entries Table which I need to filter on the first 3 letters of the Job No. pulled from the Item Budget Entries..
I am new to Jet Reports and using Express.. I have tried the function:
Should I add it as a line of code = to a variable then use the variable?
My table query looks like this so far:
=NL("Table";"Item Budget Entry";$E$12:$I$12;"Headers=";$E$11:$I$11;"TableName=";"Item Budget Entry";"Filters=";$C$5:$D$6;"InclusiveLink=Item Budget Entry";$E$10;"IncludeDuplicates=";"True")
gbierkens March 2016
I think this will be hard to achive with the express version. In the Essentials version you are able to add Excel formulas to your table.
What I would do is create two tables, one with item budget entry and one with job ledger entry. And then use excel to calculate the sums.
Or use the Essentials version, which will make your life a lot easier.
Asked in February 2016
Viewed 3,685 times
Answered 1 times
Leave an answer
Quote of the day: live life