Hi experts,
I need a logical explanation for the control commands number & and date&
The following two functions work without errors.
=NL("rows";"item";;"Qty. on Sales Order";"<70&<>0")
=NL("rows";"item";;"=NF(;""Qty. on Sales Order"")+NF(;""Qty. on Purch. Order"")";"Number&"&"<70&<>0")
But why do I need the "number&" before the cell reference in the 2nd function? What does this do?
And Do you have an example for the use of "date&"?
Thanks for your help.
Best Regards
Frank
Hi Frank
It is a subtle difference but in the first one, the field Qty on Sales Order has a type of Decimal so it is expecting a number as a filter. Jet determines the type of field in the FilterField and uses that for an expectation in the Filter.
In your second example, =NF(;""Qty. on Sales Order"")+NF(;""Qty. on Purch. Order""), while you are performing math on two fields that are Decimal types, Jet cannot determine what type it is and thus has no expectation of the type of filter to expect. Therefore, the filter value of "<70&<>0" will default to Code/Text and you end up comparing a Decimal to Code. Therefore, we have to cast the Filter as a number so we can compare apples to apples.
