When the document first open, the zRequestBy field is defaulted to @V3UserName, and the department field will return me the value of column5 in manageAdmin2 view. All of this is ok.
But when I create a nother field zOnbehalfdept which contain the formula below:
where zRequestBy(creator) can choose the zOnbehalf(name) field and return the department of on behalf. but the zOnbehalfdept never return me any value everytime i select the zOnbehalf and refresh the document.