Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.