Hi..
I am trying to fix this formula. Could anyone help me in this regards.
NewRate: IIf(([General Code]=755526 Or 755527) And ([UC]="0217" Or "0215" Or "0210" Or "0106" Or "0221"),0,[TOTAL COST QAR AVG RATE])
I need to get value "0" in case of general codes 755526 and 755527 and if UC values = 0217,0215,0210,0106,0221. Or else I need to get TOTAL COST QAR AVG RATE
Please help me!
Thanks in advance!
:-)
Bookmarks