This is very fiddly, I gave up last time I looked.
I'll have another little look.
This is the best I can come up with, which seems to behave as you've outlined.
It involves two detail sections, for the same type of line.
At the end of your formula you need to add something like:
.and.(documentitems->&linenumber=text("1").or.
documentitems->&linenumber=text("5").or.
documentitems->&linenumber=text("7").or.
documentitems->&linenumber=text("9").or.
documentitems->&linenumber=text("3"))
With the other filter being even numbers. You'd need to add as many as you'd typically get to in a quote.
In the absence of a modulus operator to follow this logic on a document with more than 10 lines, you
(last(text(documentitems->&linenumber), 1)=("1") .or.last(text(documentitems->&linenumber), 1)=("3") .or.last(text(documentitems->&linenumber), 1)=("5") .or.last(text(documentitems->&linenumber), 1)=("7") .or.last(text(documentitems->&linenumber), 1)=("9"))
Has anyone tried this? Convert the line number to a number (it's stored as text); then divide by 2, convert back to a string with 1 digit, then find the last digit.
Any odd number will return a 5; any even number would return a 0
Here's the formula
last((totext((tonumber((documentitems->&linenumber))/2)),1),1)
As this is quite a few years old now, is there an easier solution now?
It does seem odd that it's not a built-in option.
No change.
Very fiddly, but possible as detailed above.
James Shannon
I am trying to get a quote with multiple items to print out with alternate lines shaded, just like in MS Excel example below
The pic below is of "Detail Section 1" from a QW standard template. Will I have to code something like excel into QW "Detail Section 3" ? If so, how would that be coded?
1 person has this question