Field help (CSMLFOR) @ L.V. Expertise X3

Enter a formula to customize the styles for the Movements/Products grid that displays the query results. You can access the Formula wizard from the Actions icon menu in this field.

For example:

To display a red background for negative values in the Stock after field (AFTSTO), the formula would be:

[M:SML2]AFTSTO(nolign-1)<0

To display an orange background when the Allocation date (IPTDAT) is different from the Creation date, the formula would be:

[M:SML2]IPTDAT(nolign-1)<>[M:SML2]CREDAT(nolign-1)

To display a yellow background for the Average cost after field (AFTPRI) when the variation between two movements exceeds 10 %, the formula would be:

nolign<[M:SML2]NBLIG & [M:SML2]AFTPRI(nolign)<>0 & abs(1-[M:SML2]AFTPRI(nolign-1)/[M:SML2]AFTPRI(nolign))>0.1