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)

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"))

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.

This is very fiddly, I gave up last time I looked.

I'll have another little look.

## 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