I would like to know if the Nz function would work as a replacement for the IIf function in this expression:
IIf([Vol EUR Cross Org]ISNULL,0,Replace([Vol EUR Cross Org],",","."))*[Rate]))AS[PVO]
I can't seem to get the syntax correct when I try to use Nz().