How to use if condition in text box.

[kavita25]

How to use the below expression in Text box:

avg(if((ValidFrom<=[GR Date] and [GR Date] <=rangedate),(OLDRATE-NEWRATE)))

Any help, would highly appreciate.

Regards,

Kavita

[consenit · Accepted solution]

Hi there.

When used In textboxes expressions must include the equal sign at the start:

=avg(if((ValidFrom<=[GR Date] and [GR Date] <=rangedate),(OLDRATE-NEWRATE)))

Kind regards,

Ernesto.